Skip to main content
Question

Reading in a csv file but its merging the attributes into a single attribute instead of delimiting. Is there a way to fix this?


I'm new to fme and wondering if I'm doing something wrong? I've tried setting the deliminiter to auto and tried other alterations but no success. There are no issues when I read in other csv files but with this particular file its causing this issue.

 

Any help would be great!

4 replies

caracadrian
Contributor
Forum|alt.badge.img+23
  • Contributor
  • January 13, 2021

When you add the CSV reader you first click on the Parameters button so it reads the file and maps the attributes.

It is preferable to have a Header in your first rowAdding CSV reader


bertmeskens
Forum|alt.badge.img+2

Can you share a part of the CSV? If your delimiter is also used in the values, it could become very messy when using auto. Usually the parameters should give you enough control to fix this.


  • Author
  • January 14, 2021
caracadrian wrote:

When you add the CSV reader you first click on the Parameters button so it reads the file and maps the attributes.

It is preferable to have a Header in your first rowAdding CSV reader

This worked! I think I was trying to alter the parameters after the reader had already been added which wasn't working but when I did it when I added the reader it worked. Thanks!


  • Author
  • January 14, 2021
bertmeskens wrote:

Can you share a part of the CSV? If your delimiter is also used in the values, it could become very messy when using auto. Usually the parameters should give you enough control to fix this.

thanks for your suggestion! It was the auto parameter that caused it, it worked when I altered the parameters while adding the reader. Thanks for your help


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings