SPLIT
This function splits a given string by a given separator and returns the result in an array of strings.
Syntax
SPLIT( <delimiter>, <string> )
Parameters
| Parameter | Description |
|---|---|
<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"]