Split
Split Function
Splits a given string by specified delimiter into number of columns mentioned.
Syntax
Split (vector StringValue, scalar Delimiter, scalar Number)
Arguments
| Argument | Description |
|---|---|
vector StringValue | String to be inspected |
scalar Delimiter | Delimiter to be used to split |
Scalar Number | Number of columns to be returned |
Examples:
Split(array('Peter Parker', 'Clark Kent'), ' ', 2)
Splits full name by spaces into two columns.