2021.1

If any errors are encountered in one or more records, an error message will be displayed. Errors
encountered while performing the extraction workflow on the current record will also be visible
on the Messages tab.
Note
How many records are displayed in the Data Viewer (200, by default) is specified in the
Record limit on the Settings pane.
Data source settings
After opening a data file you have to make a number of settings to make sure that the source
data is interpreted and grouped the way you want. These settings are found on the Settings
pane at the left.
l Input Data settings help the DataMapper read the data source and recognize data
correctly.
l Boundaries mark the start of a new record. They let you organize the data, depending on
how you want to use them.
l Data format settings define how dates, times and numbers are formatted by default in
the data source.
Input data settings (Delimiters)
The Input Data settings (on the Settings pane at the left) specify how the input data must be
interpreted. These settings are different for each data type. For a CSV file, for example, it is
important to specify the delimiter that separates data fields. PDF files are already delimited
naturally by page, so the only input data settings for PDF files are instructions on how to parse
the text on each page.
For an overview of all options, see: "Input Data" on page323.
Settings for a CSV File
In a CSV file, data is read line by line, where each line may contain multiple fields, separated
by a delimiter. Even though CSV stands for comma-separated values, fields may be separated
using any character, including commas, tabs, semicolons, and pipes.
The text delimiter is used to wrap around each field just in case the field values contain the
field separator. This ensures that, for example, the field “Smith; John” is not interpreted as two
Page 224