1.5

Table Of Contents
l
Thousand Separator: Adds the selected character between each thousand
position (for example, "1,000,000")
l
Treat empty as 0: Considers empty spaces as 0.
l Currency
l
Negative Sign Before: Adds a negative (-) sign before negative values in the
Extracted Record.
l
Decimal Separator: Determines the character to use for decimal values, generally
a dot (.).
l
Thousand Separator: Adds the selected character between each thousand
position (for example, "1,000,000")
l
Currency Sign: Determines the character to add before the value in the Extracted
Record.
l
Treat empty as 0: Considers empty spaces as 0.
l Date
l
Date/Time Format: Determines how the date is read. The format written here needs
to correspond with the format in the data selection.
l
Language: The language in which the date is written, when relevant. Useful when
months or days are written alphabetically.
Note
Default Format Settings can be defined at the user level, at the Datamapper configuration level
and/or at the field level. (see Datamapper Default Data Format for more information).
Ordering and Renaming Fields
The Order and rename fields dialog appears from the Extract step by clicking on the Rename
Fields button next to the field list. This dialog displays the extracted fields in the currently
selected Extract step. Field extractions are executed from top to bottom. Using JavaScript
fields, it is possible to refer to previously extracted fields if they are extracted higher in this list or
in previous Extract steps in the extraction workflow.
l
Name: The name of the field. Click the field name and enter a new name to rename the
field.
Page 166