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.

On this page:

Browser not supported