2021.1

anything in the current element). If more than one item is returned, the Extract step
will keep an array of all returned items.
The full JsonPath to an element is displayed at the bottom left of the window when you
select it. To copy the path, right-click it and select Copy.
l Use selection: Click to use the value of the current data selection for the extraction.
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394dialog.
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843), the current data mapping configuration ("Data format settings" on
page227) 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
Page 350