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”,“”
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.
@AbilashBLR Thank for sending over.it was due to the Escape character changed escape char from /n to /r/n and worked first time.