Drag Text Data Provider to the Design window.
In the Text Data Provider component window, select the text file to use as a data source.
The Text Data Provider component window lets you define the structural properties of data at the OUT-port. It includes:
File Content pane – displays the contents of the source document.
Properties pane – the file description properties. You can modify the file description properties, if required. See “Text Data Provider properties list” for specific field requirements.
Output Port Content pane – a tabular view of data at the OUT-port. In the Output Port Content pane, click the “Regenerate the column definition icon to regenerate column definitions. If you want the column names to be read from a data file, click the “Read column names from a data file” icon. See “Reading column names from a data file”.
In the Output Port Content pane of the Text Data Provider component window, click the “Read column names from the data file” icon.
Provide the line number of the record that contains the column heading. Click Enter to confirm.
You can double click the column headings to edit the name of the column.
The line containing the column headings is not automatically skipped when the data is processed. To skip a specified number of rows at the beginning of the input table(s) for a load, enter a value in the “Skip First Rows” field.
If the rows to be skipped do not contain the same format as later rows; for example, if there is a “header” row with no column delimiters, while later rows all contain 5 columns, it is still counted as 1 row.
Quoted row delimiters are not regarded as row delimiters.
This section discusses the considerations to keep in mind when using quote characters, row and, column delimiters.
A value can have quote characters if:
Quotes start at the beginning of the value
Quotes surround the entire value
If a value starts with a quote, everything up to the next quote delimiter combination is read, else everything up to the next delimiter is read. For example, if Column A is a single column of data, it can be quoted as “Column A”. However, quoting values in any of these ways is invalid:
“Column” A – quotes don’t surround the entire value.
“Column “A” – quotes don’t start at the beginning of the value.
If you have 2 columns of data, say “Column A” and “Column B,” which are separated by a comma Column Delimiter and a CRLF Row Delimiter:
The value can be quoted as “Column A”, “Column B” <CRLF>.
The value cannot be quoted as “Column” A, “Column B” <CRLF>.
Here are some examples of using quote characters and delimiters:
If you are using:
Double quotes (“) as Column Quotes
Comma (,) as the Column Delimiter
Line feed (<LF>) as the Row Delimiter
If the value from the source file is:
“ABCD”, “DEF” <LF> – Column 1 will be read as ABCD and Column 2 will be read as DEF.
““A””, “D,E,F” <LF> – Column 1 will be read as “A” and Column 2 will be read as D,E,F.
““A”, “D,E”<LF> – Column 1 will be read as “A and Column 2 will be read as D,E.
