split¶
Description¶
Splits the string into an array, based on the separator.
Return type¶
array of string
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
split(value, separator)
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
value |
string |
no |
no |
none |
separator |
string |
no |
no |
constant |
Examples¶
make_col date_parts:split("2024-04-05", "-")
This splits the given string by dashes, returning a JSON array of the elements: ["2024", "04", "05"].