2020.1

l
Comment delimiter: If there are comment lines in the file, type the character that starts a
comment line.
l
Text Delimiter: Type the character that surrounds text fields in the file. Other delimiters
will not be interpreted within these text delimiters.
l
Ignore unparsable lines: When checked, any line that does not correspond to the above
settings will be ignored.
l
First row contains field names: Check this option to use the first line of the CSV as
headers. This option automatically names all extracted fields.
l
Sort on: Select a field on which to sort the data, in ascending (A-Z) or descending
(Z-A) order. Note that sorting is always textual. Even if the selected column has
numbers, it will be sorted as a text.
MDB file options
l
File: Include the full path to the file.
l
Password: If the file isn't password protected, you can click Next without filling out this
field.
l
Table name: Use the drop-down to select the appropriate table or stored query to retrieve
the appropriate data set.
l
Encoding: Use the drop-down to select the encoding with which to read the data in the
table.
l
Sort on: Select a field on which to sort the data, in ascending (A-Z) or descending
(Z-A) order. Note that sorting is always textual. Even if the selected column has
numbers, it will be sorted as a text.
XML File options
Select what level of XML elements defines a record.
The Trigger is what triggers the creation of a new record. It can be set to:
l
On element: This defines a new record when a new element occurs on the selected XML
level.
l
On change: This defines a new record when a specific field under the chosen XML level
has a new value. After selecting this option, you have to select the field that triggers the
creation of a new record.
Page 769