Function TOARRAY()

 

Description
Converts a string in array format into an array data type for use in calculations.

Syntax

TOARRAY("[textToBeParsed]")

Parameters

• textToBeParsed – String formatted as an array (must use square brackets)

Return Value
ARRAY

 

Examples

Formula

TOARRAY("[1,2,3,4]")

Result
[1,2,3,4]

Formula

TOARRAY("['a','b','c']")

Result
['a','b','c']

Formula

TOARRAY("[a,b,c]")

Result
NULL (invalid format)

Formula

TOARRAY("a,b,c")

Result
NULL (missing brackets)

Formula

TOARRAY(history)

Result
Returns array if history contains valid array string (e.g., "[1,2,3]")

Notes

• Input must be properly formatted with brackets
• Invalid formats return NULL
• Useful for converting text to usable arrays