This Analytics Edge wizard lets you split a text column into several columns. You can split on a delimiter, a fixed-width sequence, or into smart name columns.

It can be used to split name fields apart (the smart name option), or to split product codes or URLs.

Split Options

Split on delimiter –┬áselect a delimiter that separates the values in the column. Optionally enter your own sequence of characters (may be more than one).

Split fixed width – if the column is to be split at specific character positions, use this option. A second tab will appear where you can click to insert column breaks.

Smart name split – select this option to split a column into various name parts.

Split into Columns – splits the selected column into multiple columns, named with suffix -1, -2, etc.

Remove original column – to remove the column that has been split, check this option.

Split into Rows – splits multiple values in the selected column into multiple rows.

Ignore duplicates – if the column contains multiple but identical values, ignore the duplicates and create only one row for each unique value.

Pick Column – select a column by position (column letter) or By Name to be split.

Define Column Breaks

Use this tab to define column breaks in the selected column. Click to insert a column break — a red line will appear. Repeat until you have defined all of the columns.

Click a line to remove it.

Updated for v10.