cCsvWriter
Transforms the incoming data into CSV format.
cCsvWriter Standard properties
These properties are used to configure cCsvWriter running in the Standard Route framework.
The Standard cCsvWriter 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. |
|
|
Handle CSV Headers: Select the way the headers will be handled.
|
| Bean | Bean Reference: Select the Bean where your custom CSV format is defined. |
Usage
|
Usage rule |
cCsvWriter can be a middle or end component in a Route. |
|
Limitation |
n/a |