STRING_SPLIT

The string function used to split a string into multiple substrings, based on some delimiter. Unlike other functions, STRING_SPLIT returns multiple rows, one per substring.

Parameter Type
string_to_split
string
delimiter
string
Returns: string

Example

query:

SELECT STRING_SPLIT("a,b,c", ",")

results:

string_split
a
b
c

The STRING_SPLIT function requires two arguments. The first argument is the string to be split and it can be stated either as a string or as a column. The second argument is the character to split the string on.