cCsvParser Standard properties
These properties are used to configure cCsvParser running in the Standard Route framework.
The Standard cCsvParser component belongs to the Transformation family.
Basic settings
|
CSV Format |
Select the format of the CSV file for parsing from Default, Custom, RFC-4180, Excel, MySQL, Oracle, PostgreSQL CSV, PostgreSQL TEXT, Informix UNLOAD, Informix UNLOAD CSV, TDF, Bean. |
|
Custom |
Delimiter: Enter the separator you want to use as the value delimiter. |
|
|
Record Separator: Enter the record separator to delimit output records. |
|
|
Escape Character: Enter the character to be used as escape character. |
|
|
Null String: Enter the String to indicate that the value is null. |
|
|
Comment Marker: Enter the character to be written at the start of each comment line. |
|
|
Quote Mode: Select the quote policy to use for output from None, Minimal, All non-numeric values, All except null values, and All values. Enter the mapping class to be used for parsing the data into a map. In the Quote field, enter the character to be used to encapsulate values containing special characters. |
|
|
Trim values: Select this check box to trim leading and trailing blanks. |
|
|
Ignore empty lines: Select this check box to skip empty lines between records. |
|
|
Handle CSV Headers: Select the way the headers will be handled.
Select the Parse into Maps check box to produce maps for the lines values instead of lists. When this check box is selected, the Custom defined headers option appears allowing you to define custom headers in the CSV Columns table. Click [+] as many times as required to add columns to the table. Then click the corresponding value field and enter a value. |
| Bean | Bean Reference: Select the Bean where your custom CSV format is defined. |
Usage
|
Usage rule |
cCsvParser can be a middle or end component in a Route. |
|
Limitation |
n/a |