Split

The Split() function splits a text into an array of text values.

On an array (like resulting from this split) you can access a specific item by its position in the array, using the (i) (1-based) positioning indicator.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Note: The separatoris case sensitive!

Returns an array of text values split at each point where the separator occurs in the given text. Only segments that have a value are included in the returned array. When a split occurs without a value, it is not included. A space is considered as a value and will be returned as a separate array element. This can be useful for counting the number of separations, for example.

Syntax

Split(text, separator)

Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",") => ("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec")

Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",")(3) => "Mar"

Parameters

Name	Type	Required	Description
text	text	☑️	The text to split.
separator	text	☑️	Specifies the character(s) to use for separating the text.