Split Col

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Split Col

Description

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

 

Inputs

1

 

Options

Select the Column you wish to split.

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

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

 

Notes

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 Rename Col it.

 

See also

Concat Cols