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> )
Parameter Description
<delimiter> The separator to split the string by.
<string> The string to split.

Example

SELECT
	SPLIT('|','this|is|my|test') AS res;

Returns: ["this","is","my","test"]