Split
Last updated
Last updated
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 separator
is 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.
text
text
The text to split.
separator
text
Specifies the character(s) to use for separating the text.