cCsvParser

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.

  • No header line: There is no header line in the input.
  • Skip header line: Skip the header record in the output.
  • Capture headers: Collect headers into the message header.
  • Custom defined headers: 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. Select the Override header line check box to replace the first line in the CSV file with the custom defined headers. If this check box is not selected, the first line in the CSV file will be kept as a data line and the custom headers will be put above it.

  Select the Parse into Maps check box to produce maps for the lines values instead of lists. This option is available when Capture headers or Custom defined headers is selected.

Usage rule

cCsvParser can be a middle or end component in a Route.

Limitation

 n/a