Format Options - Import

On the format dialog box are you can selection the number of decimal places for the exported values and set the field separator and text delimiter characters.

Field Separator

The field separator is placed between each of the imported or exported data fields. It is initially set as a comma (,).

To change the Field Separator

• choose the desired character from the pull-down list.

Text Delimiter

The text delimiter is used to designate a text (string) field. It is initially set as a pipe (vertical line symbol “|”).

For example, if you exported a recipe using the default settings, it would look something like the following:

|Granola|,|Raisins|,1.5,3,4

|Granola|,|Almonds|,4,2,6

|Granola|,|Coconut|,4,6,2

Here the recipe name |Granola| appears on each line, followed by the ingredient name, followed by three numeric fields (quantity,measure code, and one other numeric data element).

To change the Text Delimiter

• choose the desired character from the pull-down list.

Ignore First Row of File

Check this box when you have headers in your file. If your file does not have a header row, leave this unchecked.