# cCsvParser

Extracts the desired data from 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.

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

| 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> <p> <span>Ignore empty lines</span>: Select this check box to skip empty                     lines between records.</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 in the                           input. </li> <li> <span>Skip header line</span>: Skip the header record in the                           output. </li> <li> <span>Capture headers</span>: Collect headers into the message                           header.</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.                           Select the <span>Override header line</span> 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.</li> </ul> </div> <p>Select the <span>Parse into Maps</span> check box to produce maps for                     the lines values instead of lists. This option is available when                        <span>Capture headers</span> or <span>Custom defined                        headers</span> is selected.</p> </li> </ul> |
| Bean | Bean Reference: Select the Bean where your custom CSV<br>format is defined. |

## Usage

| Usage guidance | Description |
| --- | --- |
| **Usage rule** | cCsvParser 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)