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