Split Columns window

The Split Columns window allows you to split columns of data in the Import Data window. This can be very useful for modifying input data into an appropriate format to import into PerfectTablePlan. To display this window click on the Split column(s)... button in the Import Data window (you may need to click the button to make the Split columns.. button visible).

Set the separator to the text you wish to split the column(s) at.

Select every to split at every occurrence of the separator token and the first to only split at the first occurrence.

Click OK to split the column(s) and close the window.

Click Cancel to discard the changes.

Splitting creates new columns to the right of the column(s) being split. The new columns are selected. The original column(s) is/are not changed.

For example "John Smith, CEO, Smith industries - UK" could be split into columns as follows:

Separator

Occurrence

New columns

,

every

"John Smith" "CEO" "Smith industries - UK"

,

first

"John Smith" "CEO, Smith industries - UK"

-

every

"John Smith, CEO, Smith industries" "UK"

You can carry out as many split and join operations as you need to get your data into appropriate columns.