Split Columns
This task will split one or more selected columns by the selected regular expression.
| OPTION | DESCRIPTION |
|---|---|
| Split Columns | The columns selected for splitting. |
| Split Regular Expression | The regular expression on which to split the content of the column. |
INPUT
No special requirements.
OUTPUT
The data will be split on the selected columns with the specified regular expression.
EXAMPLE
Splitting grades by a comma
Given that Split Columns is configured as follows:
The following screenshot shows the before and after of having run Split Columns configured as above.
Which may in turn be visualized in many ways within Dex as demonstrated in the following screen shot:
