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 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.