Text Data Provider properties list

Text Source

Identifies the text file you want to use as the data source. You can select the data source when you add Text Data Provider to a project or from the Properties window. To select a data source from the Properties window, click the Text Source icon, then select the file.

Columns

Click the Columns icon to open a Property sheet that lets you define columns for the data in your source file.

Row Delimiter

Select how each row is delimited:

• Position (fixed line position)

• LF (line feed)

• CR (carriage return)

• CRLF (carriage return followed by a line feed)

Alternatively, you can enter a different delimiter.

Row Length

Specify the number of characters in each fixed row, if you have selected Position as the Row Delimiter.

Column Delimiter

Select how columns are delimited:

• Position (fixed column positions)

• Tab

• Comma

• Semicolon

Alternatively, you can enter a different delimiter.

Column Quote

Specify how the values in the source file are quoted:

• None

• Single quote

• Double quote

Fixed by Bytes

Specify how to interpret the values provided for line length, column start, and column end:

• Not selected – the values are interpreted as number of characters. This is the default.

• Selected – the values are interpreted as number of bytes.

For example – Suppose your source file includes abcÖÐÎÄ abcdef and has the following characteristics:

• File Type – Fixed (Variable Line)

• Encoding – GB2312

• Row delimiter – '\n'

• Column definition – column1: 1-7; column 2: 9-10

If you select the Fixed by Bytes option:

• Column 1 displays the first 7 bytes, which are, abcÖÐÎÄ.

• Column 2 displays the 9th and 10th bytes, which are, ab.

If you do not select the Fixed by Bytes option:

• Column 1 displays the first 7 characters, which are abcÖÐÎÄ a.

• Column 2 displays the next 2 characters, which are, cd.

Null Byte Substitute

Sets the character to replace null bytes.

Skip Rows

Skips a specified number of rows in the row sequence.

Encoding

Sets the current character encoding. To set the character encoding, select the appropriate value from the drop-down menu.

Support Unicode

Sets Unicode support.

Read Block Size

Determines the number of records retrieved by the component in a single step.