2021.1

Note
If the selection contains multiple lines, only the first line is selected.
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: 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.
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.
CSV and Database Files
l Property: Displays a list of record properties set in the Preprocessor step (see
"Preprocessor step" on page255).
l Type: Displays the type of the property. Read only field.
l Based on: Determines the origin of the data.
l Location: The contents of the data selection set below will be the value of the
extracted field. The data selection settings are different depending on the data
sample type.
l Column: Drop-down listing all fields in the Data Sample, of which the value
will be used.
l Top offset: The vertical offset from the current pointer location in the Data
Sample (Viewer).
l Use selection: Click to use the value of the current data selection for the
extraction.
Page 355