Is there a way to read in the data and keep the address field in one column? Any help appreciated.
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.
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.