cCsvWriter

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.

• Handle CSV Headers: Select the way the headers will be handled.

  • No header line: There is no header line.
  • 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.

Usage rule

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

Limitation

 n/a