The SPLIT-TO-ROWS directive splits a column based on a separator into multiple records, making a copy of the record for each column value generated by splitting.
Syntax
| Code Block |
|---|
split-to-rows :column 'regex' |
The column is split based on the <separator>, which can be defined as a regular expression (regex).
Usage Notes
The SPLIT-TO-ROW directive takes a column, applies the regular expression separator, and then creates multiple rows from the split.
...
Note: This directive can only operate on columns of type string.
Examples
If we have a <separator> pattern of \n (a linefeed) over the string:
...