SPLIT

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Splits a string into an array based on a 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.

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

Split using a multi-character delimiter.

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

Use an empty delimiter to split into characters.

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

Demonstrate NULL handling with delimiter.

Returns NULL.