tostring() Function

Function

tostring( value )

Converts a value to Text. If an array is passed in, its values will be concatenated to form one string. To preserve the original array structure, use touniformstring().

See also: touniformstring()

Parameters

Returns

Text

Usage considerations

Arguments after the first are ignored.

Values that hold a Number (Decimal) data type are displayed using 7 digits of precision, when cast to a string of plain text.

This function returns a null Text when passed a null value.

Usage considerations

Do not use apply with tostring; use touniformstring() instead.

Examples

Convert an integer to a string

1
tostring(17)

Returns "17".

Convert an list of integers to a string

1
tostring({1,2,3.1})

Returns "1; 2; 3.1".

Convert a list of variant to a string

1
tostring({1, 2, "a", null, "b", "", "c"})

Returns "1; 2; a; ; b; ; c".

1
tostring({"a", {}, "b", "c"})

Returns "a; b; c".

Feature compatibility

Feedback