Text File Reader Properties

Name

Type

Required

Description

Columns

List of Text Reader Column

Yes

Contains definitions of columns which will be read from the input file.

Data Format Parameters

Data Format Parameters

Yes

General parameters for data formatting. This configuration is applied to all specified columns unless the column defines its own dataFormaParameters section. For more information, see DataFormatParameters

Encoding

String

Yes

File data encoding. The possible encodings are all encodings supported by the target Java platform. Some commonly used encodings are: ISO-8859-1, ISO-8859-2, and UTF-8.

Error Handling Strategy

Error Handling Strategy

Yes

Definition of error handling strategies that define how to respond to every error state the step can recognize. For more details, see the description of Error Handling Strategy.

Field Separator

String

Yes

String to be recognized as a field delimiter.

File Name

String

Yes

Name of the file containing the input data.

Ignored Row Reg Ex

String

No

A regular expression that is compared to lines in the input file. If a line (read as a string) matches the regular expression, the line will be ignored.

Line Max Read Length

Integer

Yes

Specified maximum number of characters per line to be read and processed. If the length of the line exceeds this value, an error occurs.

Line Separator

String

Yes

Specifies the string to be recognized as a line delimiter. The line delimiter can be any sequence of letters, although a specific symbol is often used which usually depends on the operating system where the file originated from. The special symbols are: \r = CR, \l = LF, \n = LF.

Number Of Lines In Header

Integer

Yes

Specifies the number of lines from the beginning of the file that will be excluded from processing (header lines, comments, etc).

Number Of Lines In Footer

Integer

Yes

Specifies the number of lines from the end of the file that will be excluded from processing (footer lines).

Shadow Columns

List of Shadow Column Def

No

Contains a set of columns that are not present in the input data, but should be created in the output (so that they are then available for further use as any other "real" column read from a file).

String Qualifier

String

No

String enclosing a text string. Not defined by default.

String Qualifier Escape

String

No

Escape character escaping the "stringQualifier" in the original meaning of this character. Not defined by default.

Id

String

No

Step identification string.


iWay Software