SPLIT
Splits a string by the given delimiter.
Syntax
SPLIT(STRING, DELIMITER)
Arguments
STRING
Type: string
A sequence of characters to split.
DELIMITER
Type: string
A sequence of one or more characters for specifying the boundary between separate, independent regions in plain text.
Returns
Type: array
Splits STRING on DELIMITER and returns an array.
Examples
| STRING | DELIMITER | Output |
|---|---|---|
| abc | b | ['a','c']
|
| abc | d | ['abc']
|
| abcdefg | cde | ['ab','fb']
|
| 1234567 | 345 | ['12','67']
|
| 1234567 | 0 | ['1234567']
|
| 1234567 | null
|
null
|
null
|
0 | null
|