Text To Columns Tool

The Text To Columns tool takes the text in one column and splits the string value into separate, multiple columns (or rows), based on a single or multiple delimiter(s).

Configuration Properties 

  1. Specify the field to split. Choose this field from the drop down list.
  2. Specify the delimiter (s) to use to split the data on. You can type the character in this space (i.e. &, :, ',etc.) or use the following:

    If you wanted to separate a field using a space OR tab, you would put \s\t in the delimiter. This is especially handy with the Skip Empty Fields in the Advanced Options.

  3. Choose your method for splitting:

Advanced Options

There are five advanced options that allow you to specify types of delimiters to ignore. You can select any number of these options or select none at all.