FileDataFormat Class

Character set used in the file.

JSON property name: qCodePage

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.

JSON property name: qComment

Information about the delimiter.

This property is used for delimited files.

JSON property name: qDelimiter

Positions of the field breaks in the table.

This property is used for fixed record data files.

JSON property name: qFixedWidthDelimiters

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.

JSON property name: qHeaderSize

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.

JSON property name: qIgnoreEOF

One of:

* Embedded labels (field names are present in the file)

* No labels

* Explicit labels (for DIFfiles)

JSON property name: qLabel

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.

JSON property name: qQuote

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.

JSON property name: qRecordSize

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

This property is used for fixed record data files.

JSON property name: qTabSize

Type of the file.

JSON property name: qType