2022.1

Note
If a key in a JSON file has a name that looks like a function (e.g. "TLIST(A1)"), then
the Extract step has to use a JsonPath with bracket notation instead of the default
dot notation. For information about the bracket notation see
https://goessner.net/articles/JsonPath/.
l Post Function: Enter a JavaScript expression to be run after the extraction. For
examplereplace("-","")would replace a single dash character inside the extracted
string.
l Use JavaScript Editor: Click to display the "boundaries" on page421 dialog.
l Trim: Select to trim empty characters at the beginning or the end of the field.
Data Format
Format settings can be defined in three places: in the user preferences ("DataMapper
preferences" on page893), the current data mapping configuration ("Data format settings" on
page252) and per field via the Step properties.
Any format settings specified per field are always used, regardless of the user preferences or
data source settings.
Note
Data format settings tell the DataMapper how to read and parse data from the data
source. They don't determine how these data are formatted in the Data Model or in a
template. In the Data Model, data are converted to the native data type. Dates, for
example, are converted to a DateTime object. How they are displayed in the Data Model
depends on the preferences (see "Default Format" on page893).
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.
Page 375