Skip to main content Skip to complementary content

FileDataFormat

Properties

Name Description Type
qType

Type of the file.

FileType
qLabel

One of:

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

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
qComment

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.

String
qDelimiter

Information about the delimiter.

This property is used for delimited files.

DelimiterInfo
qCodePage

Character set used in the file.

Integer
qHeaderSize

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.

Integer
qRecordSize

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.

Integer
qTabSize

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

This property is used for fixed record data files.

Integer
qIgnoreEOF

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.

Boolean
qFixedWidthDelimiters

Positions of the field breaks in the table.

This property is used for fixed record data files.

String

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!