The ASCII Text Import Wizard text format page allows you to select how the text will be formatted for the ASCII text file. The page will appear like the image below.
This page is separated into two main sections. They are:
•Delimiters and
•Text field qualifiers
Delimiters
Delimiters are special characters used to separate fields within a line of text. For example, if you have the fields "Name" , "Stock code", "Purchase quantity" and "Purchase unit" within a line, you can choose a character to separate the field names so they are easily distinguished as separate fields. If you choose to use a comma (,) as the delimiter, the line of text would appear like this:
Carrot, 6124, 10, Kilogram
The delimiter options available are:
•Comma
•Semi - colon
•Space
•Tab
•Other (you may specify)
Text field qualifiers
Text field qualifiers are characters that wrap around text fields to separate them further.
For example, if you have the fields "Name" , "Stock code", "Purchase quantity" and "Purchase unit" within a line, you can choose the qualifier to separate the field names so they are easily distinguished as separate fields. The text field qualifiers are used as well as the delimiters. If you choose to use double-quotes (") as the text field qualifier, the line of text would appear like this:
"Carrot", 6124, 10, "Kilogram"
NOTE: Text field qualifiers do not appear in numeric fields, only text fields.
The Text field qualifiers available are:
•None
•Double-quotes
•Single-quotes
The last option available is to list field names in the first line of the output file. By selecting this option the titles of the fields you are exporting will appear as header information for the file.
In the example below, we have selected to use a comma (,) as the delimiter and double-quotes (") as the text field qualifier. We have also selected to use the option to list our field names in the first line.
See the following image.
Select both a delimiter and a text field qualifier to best suit your needs and click the "Next" button to move to the Save changes page.