GetFileTablesEx method

Type of the file.

One of:

• embedded labels (field names are present in the file)
• no labels
• explicit labels (for DIFfiles)

One of:

• None (no quotes)
• MSQ (Modern Style Quoting)

• Standard (quotes " " or ' ' can be used, but only if they are the first and last non blank characters of a field value.)

This property is used for delimited files.

String that marks the beginning of the comment line.

Example: “#” or “//”

The engine ignores the commented lines during the data load.

This property is only used for delimited files.

Information about the delimiter.

This property is used for delimited files.

Character set used in the file.

Size of the header.

Example: If the header size is 2, the first two rows in the file are considered as header and not as data. The header can contain the field names.

Record length.

Each record (row of data) contains a number of columns with a fixed field size.

This property is used for fixed record data files.

Number of spaces that one tab character represents in the table file.

This property is used for fixed record data files.

Is set to true, the end-of-file character is not taken into account during reload.

This property is used for delimited files and fixed record data files.

Name of the delimiter.

Example:

"Tab_DELIMITER"

Representation of the delimiter value that is used in the script.

Example:

"'\t'"