SPLIT

Splits text input into a List of values based on the specified delimiter character.

Syntax

SPLIT(input, delimiter, optionalIndex)

Examples

SPLIT({{nfcField}}, ',', 2) returns the 3rd element in the comma seperated list
SPLIT('AAA|BBB|CCC', '|', 0) is AAA
SPLIT('AAA,BBB,CCC', ',') is a list with AAA, BBB and CCC as it's elements
MAX(SPLIT('1-2-5-4-3', '-')) is 5
SPLIT('AAA,BBB,CCC', ',' , 99) is BLANK as there is not 100 elements in the input list

Notes

The resulting List can be used within aggregate functions such as SUM() or COUNT().
If optional zero-based index is specified, then returns the single value at the given index or BLANK if the index is not within the list.