SPLIT

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Splits a string into an array based on a delimiter.

1split(<string>, <delimiter>)

• <string>: The text string to split.
• <delimiter>: The delimiter string to split on.

Returns an array of text values that contains the split segments.

• Given a NULL delimiter, the function returns NULL.
• An empty delimiter splits the string into individual characters.
• The function supports delimiters longer than one character.

Split a string on a comma delimiter.

1SELECT split('apple,banana,cherry', ',') AS result;

Returns array['apple', 'banana', 'cherry'].

Split using a multi-character delimiter.

1SELECT split('one::two::three', '::') AS result;

Returns array['one', 'two', 'three'].

Use an empty delimiter to split into characters.

1SELECT split('hello', '') AS result;

Returns array['h', 'e', 'l', 'l', 'o'].

Demonstrate NULL handling with delimiter.

1SELECT split('hello', NULL) AS result;

Returns NULL.

• SPLIT_PART
• Array Type
• String Types