# CSV Reader Confirguration

**URL:** <https://forum.knime.com/t/csv-reader-confirguration/78061>\
**Category:** KNIME Analytics Platform\
**Created:** [March 22, 2024, 3:45pm UTC](https://forum.knime.com/t/csv-reader-confirguration/78061 "2024-03-22T15:45:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![SergioSB](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/ecccb3/32.png) [@SergioSB](https://forum.knime.com/u/SergioSB)\
**Post date:** [March 22, 2024, 3:45pm UTC](https://forum.knime.com/t/csv-reader-confirguration/78061/1 "2024-03-22T15:45:53Z")

</div>

Hi Team, I hope you are doing well

I need to configurate the CSV Reader Node, but I don’t know how can separate columns. Below you can find the image of my data .

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/1/a/1a763686ce8c9f3354bda12ad2ea9c7c38ce8cf4.png)  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/1/a/1a763686ce8c9f3354bda12ad2ea9c7c38ce8cf4.png)

I really appreciate it if you can advice me!

---

<div class="post-metadata">

**Author:** ![Daniel\_Weikert](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/d/e47c2d/32.png) [@Daniel\_Weikert](https://forum.knime.com/u/Daniel_Weikert)\
**Post date:** [March 22, 2024, 4:18pm UTC](https://forum.knime.com/t/csv-reader-confirguration/78061/2 "2024-03-22T16:18:23Z")

</div>

Hi  
Your current Column Delimiter is a pipe and comma but I only see pipes in your data with spaces and no commas. Try to remove the comma and further adjust the exact delimiter  
br

---

<div class="post-metadata">

**Author:** ![HansS](https://forum-cdn.knime.com/user_avatar/forum.knime.com/hanss/32/6979_2.png) [@HansS](https://forum.knime.com/u/HansS)\
**Post date:** [March 22, 2024, 4:20pm UTC](https://forum.knime.com/t/csv-reader-confirguration/78061/3 "2024-03-22T16:20:36Z")

</div>

Hi @SergioSB

An the go to the tab “LImit Rows” and adjust the settings to skip the first rows.  
 ![afbeelding](https://forum-cdn.knime.com/uploads/default/original/3X/2/f/2f0491ce999984fc18006175664c0e77cd720052.png)  
gr. Hans

---

<div class="post-metadata">

**Author:** ![hapisnake](https://forum-cdn.knime.com/user_avatar/forum.knime.com/hapisnake/32/73724_2.png) [@hapisnake](https://forum.knime.com/u/hapisnake)\
**Post date:** [March 26, 2024, 4:17am UTC](https://forum.knime.com/t/csv-reader-confirguration/78061/4 "2024-03-26T04:17:12Z")

</div>

@SergioSB  
Skip first 3 rows, and choose column as header, in delimeter use | to create the columns or use autodetect format, it helps to convert to correct format.

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [June 24, 2024, 4:17am UTC](https://forum.knime.com/t/csv-reader-confirguration/78061/5 "2024-06-24T04:17:32Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.