Text split | TEXT_SPLIT

Syntax

TEXT_SPLIT( [value], [separator] )

Parameters

value
The TEXT to split. If it is not a TEXT value, it will be converted to one with the STRING operation.

separator
A TEXT to split the VALUE. If it is not a TEXT it will be converted to one with the STRING operation. It may be in a regular expression format, in which case the split will happen with the regular expression.

Return Value

An ARRAY of TEXT values.

Description

Split a TEXT into multiple TEXT values.

Examples

TEXT_SPLIT("four score and seven years", " ") # returns ["four", "score", "and", "seven", "years"]

TEXT_SPLIT("") # returns [""]

TEXT_SPLIT(null) # returns [""]

TEXT_SPLIT(1234) # returns ["1", "2", "3", "4"]