SPLIT

Splits a string into an array using the specified delimiter. The resulting array is subscripted ZERO-based, with negative indexes counting back from the end: SPLIT('a.b.c.d','.')[0] is 'a', [1] is 'b' and [-1] is 'd'. Most SQL dialects index from 1, so a query ported from one of those returns the wrong element rather than an error - an out-of-range index gives NULL, not a failure.

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.