Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt

Use this file to discover all available pages before exploring further.

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