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
Click a line to remove it.
Updated for v8.2.