Text Wizard: Step 4 (Delimited Files)

This step specifies delimiters and text qualifiers that are used in the text data file. You can also specify the treatment of leading and trailing spaces in string values.

Which delimiters appear between variables?

The characters or symbols that separate data values. You can select any combination of spaces, commas, semicolons, tabs, or other characters. Multiple, consecutive delimiters without intervening data values are treated as missing values.

What is the text qualifier?

Characters that are used to enclose values that contain delimiter characters. The text qualifier appears at both the beginning and the end of the value, enclosing the entire value.

Leading and Trailing Spaces

Controls the treatment of leading and trailing blank spaces in string values.

Remove leading spaces from string values

Any blank spaces at the beginning of string values are removed.

Remove trailing spaces from string values

Blank spaces at the end of a value are ignored when the defined width of string variables is calculated. If Space is selected as a delimiter, multiple consecutive blank spaces are not treated as multiple delimiters.