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 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.
Syntax
Parameters
Last updated