1.4

l Integer
l
Negative Sign Before: Adds a negative (-) sign before negative values in the
Extracted Record.
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 Float
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
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).
Page 138