Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • 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.

Could you attach an example of your data?

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


Community Stats

30,123
Posts
114,333
Replies
37,751
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.