2020.2

page in a PDF file.
It can also be something in the data that is either static (for example, the text "Page 1 of" in a
PDF file) or changing (a customer ID, a user name, etc).
To define a more complex trigger, you can write a script (see "Setting boundaries using
JavaScript" on page377).
A new record cannot start in the middle of a data field, so if the trigger is something in the data,
the boundary will be set on the nearest preceding natural delimiter. If for instance in a PDF file
the text "Page 1 of" is used as the trigger, the new record starts at the page break before that
text.
For an explanation of all Boundaries options per file type, see "Boundaries" on page322.
Data format settings
By default the data type of extracted data is a HTMLString, but each field in the Data Model can
be set to contain another data type (see "Data types" on page279). When that data type is
Date, Number or Currency, the DataMapper will expect the data in the data source to be
formatted in a certain way, depending on the settings.
The default format for dates, numbers and currencies can be set in three places: in the user
preferences, in the data source settings, and per field in the Data Model.
By default, the user preferences are set to the system preferences. These user preferences
become the default format values for any newly created data mapping configuration. To change
these preferences, select Window > Preferences > DataMapper > DataMapper default
format (see "DataMapper preferences" on page829).
Data format settings defined for a data source apply to any new extraction made in the current
data mapping configuration. These settings are made on the Settings pane; see "Settings
pane" on page316.
Settings for a field that contains extracted data are made via the properties of the Extract step
that the field belongs to (see "Setting the data type" on page270). 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
Page 225