SPLIT¶

Description¶

SPLIT splits a string by a separator and returns a list of the resulting parts. An optional third argument limits the maximum number of splits performed; the remaining unsplit portion is returned as the last element.

Syntax¶

SPLIT(string, separator, max_splits?)

Returns: A list of strings.

Example¶

SPLIT('a,b,c,d', ',')

This returns ['a', 'b', 'c', 'd'].

Example with max splits¶

SPLIT('a,b,c,d', ',', 2)

This returns ['a', 'b', 'c,d'] — only two splits are performed, so the remainder is kept as a single element.