Specifying the delimiter used in the text file is the third of four steps in the process of importing ASCII files, depending on the delimiter format selection made in Step 2. If the text fields in the file are separated by a fixed-width, then that selection must be made in Step 2, and a different dialog is used for Step 3 to set column widths. If the text files being imported are delimited by one or more characters, the characters used to separate each field must be specified here, in the Step 3 dialog of the ASCII Import Wizard.

Once you select the delimiter character, the ASCII Preview Window is updated with the current selection(s). A pipe symbol (|) is used in place of the actual character(s) to separate the fields in the ASCII Preview Window.

Learn more about the ASCII Preview Window
 

Step 3: Select Delimiters

Selecting the Delimiter

1. Complete Steps 1 and 2 of the ASCII file import process if you have not already done so. See ASCII Import Wizard for the list of steps.

2. On the Step 3 page, click the check box(es) for the delimiter(s) used in the text files to separate each field. 

   If the character used to separate each field is not listed as a check box, check the Other check box and enter the character in the box.

   

   Note  A pipe symbol (|) is used in place of the actual character to separate the fields in the ASCII Preview Window.

3. Click Next to go to the next step.