Note: This function is available in SharpCloud v9.2.0408 and later.

TOARRAY function is used to convert a string into an array data type. This can be useful as the array’s can then be used in other calculated values, a limitation of string values.

Syntax

TOARRAY(“[x,x,x,x]”)

Parameters

x = Values that are part of the array.

Data Type Returned

Values that are returned will be an array.

Examples

TOARRAY(“[1,2,3,4]”) will return [1,2,3,4]

TOARRAY(“[a,b,c]”) will return NULL as a is not a valid object

TOARRAY(“[‘a’,’b’,’c’]”) will return [“a”,”b”,“c”]

TOARRAY (“a,b,c”) will return NULL as the text is not enclosed in square brackets “[]”

TOARRAY(history) where the history attribute is a text attribute with the values of ‘[1,2,3]’. This will return [1,2,3].