The SPLIT-TO-COLUMNS directive splits a column based on a regular expression into multiple columns.
Syntax
| Code Block |
|---|
split-to-columns :column 'regex' |
The column is split into one or more columns around matches of the specified regular expression regex.
Usage Notes
The SPLIT-TO-COLUMNS directive takes a column, applies the regular expression separator, and then creates multiple columns from the split. The name of the columns are in the format:
...
Note: This directive can only operate on columns of type string.
Examples
If we have a <separator> pattern of , (a comma) over the string:
...