Page 1 of 1
How to deal with comma in description when using TRANSFORM_FILE to read CSV file?
Posted: Thu Oct 24, 2019 2:11 am
by 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?
Re: How to deal with comma in description when using TRANSFORM_FILE to read CSV file?
Posted: Fri Oct 25, 2019 3:40 am
by 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.
Re: How to deal with comma in description when using TRANSFORM_FILE to read CSV file?
Posted: Fri Oct 25, 2019 4:07 am
by 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?!
Re: How to deal with comma in description when using TRANSFORM_FILE to read CSV file?
Posted: Fri Oct 25, 2019 4:20 am
by 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 5761 times