Split Col

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Split Col


Creates one or more new columns by splitting text at delimiters in a selected column.






Select the Column you wish to split.

Supply the Delimiter you wish to use to split the column.

Set Ordering depending on how you want to order values after splitting.

Check keep empty if you wish to honor delimiters with nothing in between.

set Min. new cols to the minimum number of new columns you wish to add.

set Max. new cols to the maximum number of new columns you wish to add (ignored if less than minimum).



If no Delimiter is supplied then no new columns are created.

New columns are added at the right end. You can change the column order with Reorder Cols.

If there is a header, the header of the new column is based on the original header. You can change the column name with Rename Cols.

The opposite of Split Col is Concat Cols.


See also

Split Rows