How to deal with comma in description when using TRANSFORM_FILE to read CSV file?

[eddie9394]

I am using the TRANSFORM_FILE to read a CSV file into a list, it works fine most of the time, but when there is a comma in the description field, it will shift everything off, I try to double-quote the description field and it is not working. Is there any way to deal with this issue?

[atostaine]

If there are double quotes around the description with the comma then it should work. If you are sure you have "description, and a comma" then something else is wrong.

[eddie9394]

Thanks for the help!

Yes, I did have double quotes around the description. Please refer to the uploaded screen snip.

You suggested something else is wrong, where should I start the search?!

[atostaine]

My test is doing that also. Looks like a bug in transform_file. Whenever I import CSV's using IBM i or Excel the double quote is valid.

Untitled.png (4.12 KiB) Viewed 5763 times