1.4

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).
CSV and Database Files
l
Property: Displays a list of Source Record properties set in the Preprocessor Step.
l
Type: Displays the type of the Source Record property. Read only field.
l
Based on: Determines the origin of the data.
l
Location: The contents of the data selection set below will be the value of the
extracted field. The data selection settings are different depending on the data
sample type.
l
Column: Drop-down listing all fields in the Data Sample, of which the value
will be used.
Page 142