1.7

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116).
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.
Note
If the selection contains multiple lines, only the first line is selected.
l
Trim: Select to trim empty characters at the beginning or the end of the field
l
JavaScript : The result of the JavaScript Expression written below the drop-down
will be the value of the extracted field. If the expression contains multiple lines, the
last value attribution (variable = "value";) will be the value. See "DataMapper Scripts
API" on page228.
l
Expression: The JavaScript expression to run.
l
Use JavaScript Editor: Click to display the Edit Script dialog (see "Using
scripts in the DataMapper" on page230 and "DataMapper Scripts API" on
page228).
Page 204