Hi there,
I am trying to read a CSV file which has commas embedded within certain fields.
Eg.
"Joe Bloggs", "123 Bloggs Street, Bloggsville, MA, USA", "123.34", "XYZ"
"John Doe", "12 JD Avenue, MA, USA", "53.2", "QRS"
As you can see I have the same amount of fields with a differing amount of comma characters in each. I was using the comma character (',') to split my string into different fields but this gave me varied results.
I have no control over the format of the file so restrucuring it is not an option.
Is there a way where I can split the string by using the comma and maintaining the address field as a single field.
Thanks in advance,
B
...
Go to the complete details ...