Multiple fixed width record files

Classification

Select Multiple Records Fixed Width.

Name

Specify a unique name for the new data format.

Description

Specify a description for the new data format.

Description

The description that was entered when the data format was created.

Initial lines to ignore

The number of lines at the start of the external file that are to be ignored. The default is 0.

Record Separator

The code that is used at the end of each record in the external file in order to separate the records. Select Windows New Line, UNIX New Line or Other. Windows New Line is the default separator and is displayed in the script as record-sep="\r\n", that is, carriage return and new line.

To specify a different separator, select Other. This enables the Specify field for you to specify the separator.

In the Fields section, in the Start, Length and Field columns, click in a row marked with a '*' asterisk to enter the start position (numeric), length (numeric) and name of the field. The name of the field must conform to XML syntax, for example, it cannot start with a numeric character. The field name must also be unique within the data format.

Use these buttons to import field names or to insert or delete fields:

• Read File

  To import existing field names from an example file, click Read File and browse to the location of your file. The field names are extracted and inserted into the rows, replacing any field names you have already defined.

  Note: All files being imported must be in UTF-8 format.
• Insert

  Click Insert to add an additional new row above the currently selected row.

• Delete

  Click Delete to remove the currently selected row.

Records

In the Records section:

• To add a record, click Add. This displays an additional tab for you to enter the record details.
• To delete a record, select an existing record tab, and click Delete.

To complete the record details, specify this information:

Prefix

The string that identifies the start of each record.

Record Name

The name that identifies each record.

Field

The start position, length, and field names that define the fixed width data in the external file. Click in a row marked with an '*' asterisk to enter new field names. These must conform to XML syntax, for example, they cannot start with numeric characters. The field names must also be unique within the field set.

Check the check boxes in the Ignore column for any rows that you do not want to be used, for example, you may want to ignore the spaces between each field name.

Use these buttons to import field names or to insert or delete fields:

• Read File

  To import existing field names from an example file, click Read File and browse to the location of your file. The field names are extracted and inserted into the rows, replacing any field names you have already defined.

  Note: All files being imported must be in UTF-8 format.
• Insert

  Click Insert to add an additional new row above the currently selected row.

• Delete

  Click Delete to remove the currently selected row.

Use these buttons to import field names, insert or delete fields:

To sort the order of the field names, select the field you want to move and click Up or Down as appropriate.