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

Userlevel 3
Badge +26

Could you attach an example of your data?

Userlevel 4
Badge +36

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.

Reply