Delimiters

Specify delimiters on which the selected column will be parsed into multiple columns.

For example, to parse a column with data of the format “ 10_5N_1 ”, specify the underscore ( _ ) to create three new columns with one containing “ 10 ”, another containing “ 5N ”, and the other containing “ 1 ”.

To Specify Delimiters for Parsing:

Type the delimiters into the Delimiters text box. Separate multiple delimiters with spaces .