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.

  • April 4, 2023
  • 2 replies
  • 5 views

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+31
  • Influencer
  • 627 replies
  • April 4, 2023

Could you attach an example of your data?


geomancer
Evangelist
Forum|alt.badge.img+58
  • Evangelist
  • 932 replies
  • 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 string, 123, "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.