Format Options - Export

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.

Write Field Headings to First row

The first row will display field headings. Example: Name, User Code, Calories, Fat, etc.

Write Mode

• Choose Overwrite for this export to overwrite all of the information in the previous export of the same name
• Choose Append to add the data from this export to the end of the export of the same name.