SPLIT

Splits a string into an array using the specified delimiter.

Category: String Functions

Syntax

SPLIT(string, delimiter)

SPLIT(string, delimiter, limit)

Arguments

• string varchar String input value.
• delimiter varchar Separator used to split the input string.
• limit integer Maximum number of items or splits to return.

Returns

array<element type of string> — Returns an array whose element type is the string type of string — the parts are substrings of the input, so the element type is fixed and known.