Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API
Splits a string into an array based on a delimiter.
Syntax
split(<string>, <delimiter>)
Arguments
Required
<string>: The text string to split.<delimiter>: The delimiter string to split on.
Returns
Returns an array of text values that contains the split segments.
Considerations
- 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.
Examples
Split on Delimiter
Split a string on a comma delimiter.
SELECT split('apple,banana,cherry', ',') AS result;
Returns array['apple', 'banana', 'cherry'].
Split with Multi-Character Delimiter
Split using a multi-character delimiter.
SELECT split('one::two::three', '::') AS result;
Returns array['one', 'two', 'three'].
Split into Individual Characters
Use an empty delimiter to split into characters.
SELECT split('hello', '') AS result;
Returns array['h', 'e', 'l', 'l', 'o'].
NULL Delimiter
Demonstrate NULL handling with delimiter.
SELECT split('hello', NULL) AS result;
Returns NULL.