2021.2

l Data Format: Data format settings tell the DataMapper how certain types of data are
formatted in the data source. Make sure that this format matches the actual format of the
data in the data source.
l Negative Sign Before: Any value in a numeric field that has a "-" sign is interpreted
as a negative value.
l Decimal Separator: Set the decimal separator for a numerical value.
l Thousand Separator: Set the thousand separator for a numerical value.
l Currency Sign: Set the currency sign for a currency value.
l Date Format: Set the date format for a date value.
l Automatic: Select this option to parse dates automatically, without specifying
a format. This is the default setting for new Date fields.
l ISO8601: This setting allows for dates with different timestamp formats, or
belonging to different time zones, to be parsed inside a single job. Dates that
do not include a specific time are automatically considered to use the current
locale's time zone.
Select the ISO template to be used when parsing the timestamp. Other
ISO8601 formats can be handled via the Custom option.
l Custom: Set a custom date format. For the markers available in the
DataMapper see "Defining a date/time format" on page290.
l Language: Set the language for a date value (ex: If English is selected, the term
May will be identified as the month of May).
l Use offset from UTC: Select the default time zone, which is to be used to extract
any timestamp that does not already include time zone information with the time.
l Treat empty as 0: A numerical empty value is treated as a 0 value.
Run JavaScript
Running a JavaScript expression offers many possibilities. The script could, for example, set
record properties and field values using advanced expressions and complex mathematical
operations and calculations.
l Expression: The JavaScript expression to run (see "DataMapper Scripts API" on
page384).
l Use JavaScript Editor: Click to display the Edit Script dialog.
l Use selected text: Inserts the text in the current data selection in the JavaScript
Expression. If multiple lines or elements are selected, only the first one is used.
Page 360