Link Search Menu Expand Document

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"]