Read Schema (Delimited) Reference

The delimited read schema has some attributes, you can check the following table for the attributes and corresponding description:

Attribute Name Description
Name The file record names have alphanumeric characters only and have 80 characters at most. Each name is unique within the adapter configuration.
Description (Optional) A short description for the delimited file record.
Position From Header This field is available only for records that are defined as immediate child record of the root record. Select Begin or End based on the structure of the actual records in the data file.
Strip Blanks Select this check box to remove the blank spaces for each field identified for a record in a data file.
Repeating Delimiter Specifies whether to ignore repeated delimiters. Select this check box to translate any repeated delimiters between fields as only one field separator. Clear this check box to translate repeated delimiters as empty fields.
Delimiter Specifies the separator between fields within each line of a file for the line that is parsed. Space, Tab and Other are the available options. If you select Other, the Delimiter Other field becomes available.
Delimiter Other This field is available only if you select Other from the Delimiter field. Specifies the delimiter to be used. You can specify single or multiple characters as a delimiter.

To distinguish delimiter characters from actual field values, you can enclose data fields including the delimiter characters in double quotes and set the adfiles.quotedField property to ON in the adfilesagent.tra file (in the TIB_ADFILES_HOME\bin directory).

For example, a John, "3301 Hillview Ave, Palo Alto CA" comma-delimited record is treated as two fields because of the double quotes.

Note: Quoted field is supported with regular records only. Container records and End-of-line cannot be enclosed in double quotes.
Identifier Type Specifies the method to identify a record. Field Value (constant field value) and Number of Fields are the available options.

When the Identifier Type field is set to Field Value, the constant attribute for one of the fields is specified when defining the fields for the records. When the Identifier Type field is set to Field Value, Publication Service can also be configured to check the field count in addition to the constant field value in validating a delimited record.

For example, a read schema defines a record to contain three String fields with the first field containing a constant string "Order". A record, such as "Order,ID1234,Aug20" is accepted by Publication Service. However, a record with a valid constant Order but contains four fields, such as "Order,ID1234,Aug20,CA" is rejected. The following error is logged: 1 lines couldn't be interpreted.

To use this feature, you have to set the adfiles.matchFieldCountAndRecordLength property to ON in the adfilesagent.tra file (in the TIB_ADFILES_HOME\bin directory).

Note: Only one constant field value can be used to identify a record.
Is Base Record Select this check box to indicate the current record is a base record.