Text format page

<< Click to Display Table of Contents >>

Navigation:  Help > Tools > Export Wizard > ASCII Text Export Wizard >

Text format page

The ASCII Text Export 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.

 

asciitextexporttextpage

 

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.

 

asciitextexporttextpage2

 

 

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.