TOSTRING

(Object Object)
Returns the text representation of the object.
Example: ToString(123) return string representation of the number (123).
Object: Required. The value you want to get string representation for.
Numeric values, dates, strings are supported
(Object Objectstring Pattern)
Returns the text representation of the object.
Example: ToString(123, '0###') return string representation of the number (0123).
Object: Required. The value you want to get string representation for.
Numeric values, dates, strings are supported
(Object Objectstring Patternstring cultureCode)
Returns the text representation of the object.
Example: ToString(123, '0###', 'en-US') return string representation of the number (0123).
Object: Required. The value you want to get string representation for.
Numeric values, dates, strings are supported

Example 1

The CONCATENATE function operates on strings only. TOSTRING is used to convert from integer to string:

concatenate(left(tostring(&CPR),6),"-",right(tostring(&CPR),4))

Example 2

Month names in German:

tostring(&Date,"MMMM","de-DE")

Locale ID examples:

  • Danish = da-DK
  • German = de-DE
  • Dutch = nl-NL
  • English US = en-US
  • French = fr-FR

Full Locale ID list: Locale ID reference

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.