# cCsvWriter

Transforms the incoming data into CSV format.

Information noteNote: This component is available only if you have installed the R2024-10 Talend Studio Monthly update or a later one delivered by Talend. For more information, check with your administrator.

## 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

| Properties | Description |
| --- | --- |
| CSV Format | Select the format of the CSV file for parsing from<br>Default, Custom,<br>RFC-4180, Excel,<br>MySQL, Oracle,<br>PostgreSQL CSV, PostgreSQL<br>TEXT, Informix UNLOAD,<br>Informix UNLOAD CSV, TDF,<br>Bean. |
| Custom | <ul> <li> <p> <span>Delimiter</span>: Enter the separator                     you want to use as the value delimiter.</p> </li> <li> <p> <span>Record Separator</span>: Enter the record separator to delimit                     output records.</p> </li> <li> <p> <span>Escape Character</span>: Enter the character to be used as                     escape character.</p> </li> <li> <p> <span>Null String</span>: Enter the String to indicate that the value                     is null.</p> </li> <li> <p> <span>Comment Marker</span>: Enter the character to be written at the                     start of each comment line.</p> </li> <li> <p> <span>Quote Mode</span>: Select the quote policy to use for output                     from <span>None</span>, <span>Minimal</span>,                        <span>All non-numeric values</span>, <span>All except null                        values</span>, and <span>All values</span>. Enter the mapping                     class to be used for parsing the data into a map. In the                        <span>Quote</span> field, enter the character to be used to                     encapsulate values containing special characters.</p> </li> <li> <p> <span>Trim values</span>: Select this check box to trim leading and                     trailing blanks.</p> </li> <li> <div> <span>Handle CSV Headers</span>: Select the way the headers will be handled.<ul> <li> <span>No header line</span>: There is no header line. </li> <li> <span>Custom defined headers</span>: Define custom headers in                           the <span>CSV Columns</span> table. Click <span>[+]</span> as many times as required to add columns                           to the table. Then click the corresponding value field and enter a                           value.</li> </ul> </div> </li> </ul> |
| Bean | Bean Reference: Select the Bean where your custom CSV<br>format is defined. |

## Usage

| Usage guidance | Description |
| --- | --- |
| **Usage rule** | cCsvWriter can be a middle or end<br>component in a Route. |
| Limitation | n/a |

**Related concepts**

* [Extracting and transforming data in CSV format](https://help.qlik.com/talend/en-US/mediation-components/8.0/mediation-csv-processing/extracting-and-transforming-data-in-csv-format)