1.8

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 : A negative sign will be displayed before any 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
Date Language : Set the date language for a date value (ex: If English is selected,
the term May will be identified as the month of May).
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252).
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.
l
Use selection: Click to use the value of the current data selection.
Note
If the selection contains multiple lines, only the first line is selected.
Repeat step properties
The Repeat step adds a loop to the extraction workflow; see "Steps" on page140 and
"Extracting transactional data" on page124.
Page 231