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
Page 147