Hi,
I have used csv in past without any issues, but now I am running into csv data issue.
Now, I have csv, saved from excel and problem is the way data is being wrapped within each cells when data itself contains comma.
It would be straight forward to use Comma as Child Delimeter, when csv data looks like this
1,1001,"First Name", "Addr1", "Addr2"
2,1002,"First Name", "Addr1", "Addr2"
But the csv I have looks like this
1,1001,"First Name", "Addr1, something", "Addr2"
2,1002,"First Name", "Addr1, something else", "Addr2"
Now when I use "," as Child Delimiter, it splits Addr1 into following data field and last one is falling apart failing the instance validation.
Any idea how to handle this kind of data?
Appreciate any guidance.
Thanks,
Harish