This function splits a given string by a given separator and returns the result in an array of strings.

​
Syntax

SPLIT( <delimiter>, <string> )

​
Parameters

ParameterDescription
<delimiter>The separator to split the string by.
<string>The string to split.

​
Return Types

ARRAY TEXT

​
Example

The following example splits the nicknames of players into separate items in an array:

SELECT
	SPLIT('|','stephen70|esimpson|ruthgill|') AS nicknames;

Returns

["stephen70","esimpson","ruthgill"]