Skip to main content
Question

Hello, I am reading in numerous CSVs which use a comma as the delimiter. However the address field also has commas within it, so therefore it is misaligning the data with its headings.


Is there a way to read in the data and keep the address field in one column? Any help appreciated.

2 replies

dustin
Influencer
Forum|alt.badge.img+30
  • Influencer
  • April 4, 2023

Could you attach an example of your data?


geomancer
Evangelist
Forum|alt.badge.img+48
  • Evangelist
  • April 4, 2023

When the delimiter is also a character used in the values, these values should be enclosed in the CSV in double-quote characters:

Some string123"North Road, Eastern Village"456

If the double-quote characters are missing, we may be able to add them in FME, but to do this it would really help to have a sample of your data.


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