CSV Parsing issue with double quotes
Hello,
I have an issue where we are receiving a CSV formatted file with "" around each field.
Issue is the parse fails on the last field if it is empty if the final field is populated on all lines it will process entire file otherwise it will fail the entire file.
See below;
"test","test2",""
"test","test2","test3"
"test","test2",""
Accepted Solution
Updated: 25 May 2021 12:02 EDT
Jetty Technologies Limited
GB
@AbhilashBLR Thank for sending over.it was due to the Escape character changed escape char from /n to /r/n and worked first time.
Capgemini
IN
If column data is a free text and converted to csv with "" as delimiter then there can be lots of issues based on special characters user entered.
We made external system to create csv file with "|" pipe symbol as delimiter and issue was resolved.
Accepted Solution
Updated: 25 May 2021 12:02 EDT
Jetty Technologies Limited
GB
@AbhilashBLR Thank for sending over.it was due to the Escape character changed escape char from /n to /r/n and worked first time.