My problem is if you looked at it that address is “sangavi,pune”. But
whenever I am printing the row values. I am getting row[1] as “sangavi”
and row[2] as “pune”, which is not correct, Can anyoneone tell me how
should I solve this problem?
Get the original data in a better format than CSV?
Get the provider of the original data to export to CSV properly so address becomes “sangavi,pune” rather than sangavi,pune?
Make a guess (probably incorrect) that the address may have multiple commas, but the details won’t - then do pre-processing on the file (or stream) using regexes to wrap the address in quotes?
GOOD LUCK!
Cheers,
Andy