Split Col

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Split Col

Description

Split text at delimiters in a selected column to create multiple columns or rows.

 

Example

Split the 'Courses' column into multiple columns or rows:

 

how to split column into columns or rows by delimiter example

 

Split the 'URL' column into multiple columns using a regular expression for colon or slash or question mark or ampersand:

 

split-col-example-2

 

Inputs

One.

 

Options

Select the Column you wish to split.

Set Using depending on whether you wish to split use a text delimiter (usually a single character) or a regular expression.

Supply the text or regular expression Delimiter for splitting the column. E.g. , (comma).

Set Into to:

oColumns to create a new column for each split value.

oRows to create a new row for each split value (the original row is removed).

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

Check keep empty if you wish to keep empty values (e.g. honor delimiters with nothing in between).

set Min. values to the minimum number of columns/rows you wish to split each value into.

set Max. values to the maximum number of columns/rows you wish to split each value into (ignored if less than minimum).

 

Notes

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

If Into is Columns, 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 with Into as Columns is Concat Cols.

The opposite of Split Col with Into as Rows is Unique.

 

See also

Split Rows