I have a bot reading a CSV that sometimes will have a single double quote (“) symbol. Once it attempts to read the field with this symbol, it will fail and produce the error “Unterminated quoted field at end of CSV line”. Typical code will always have two double quotes (“ “) at the beginning and end of a value, so I see why it is trying to find the other quote. What is the best way to develop around this, to where the bot would remove the single double quote and proceed as if there were no symbol?
Solved
"CSV/TXT: Read" action unable to read data with an unterminated quote
Best answer by jeven.delacruz
Hi
Have you tried the following:
1. Rename the CSV to a txt file. using
- Use a get text string function to get all text.
- Use a replace string regex operations:
(?<!")"(?!")
- Use log to re-write the CSV to a new filename (e.g. processed_[Name].csv)
highly advised to use UTF8 encoding.
- Read the new CSV processed.csv
Let me know how it turns out 😀
+2Hi
Can you please check the lines /fields that end with “ which may not have “ at start or may not have have “ at end but at start. and add the missing quotation mark at the appropriate place.
Anjali KK
Hi
Thank you!
1 person likes this
Hi
Hi
Have you tried the following:
1. Rename the CSV to a txt file. using
- Use a get text string function to get all text.
- Use a replace string regex operations:
(?<!")"(?!") - Use log to re-write the CSV to a new filename (e.g. processed_[Name].csv)
highly advised to use UTF8 encoding. - Read the new CSV processed.csv
Let me know how it turns out 😀
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.