I tried to read a .CSV file into an array of string. I can use the
string.split method to do it if the .CSV file just contain "," without
quotas. But if there is quota, split function can't handle it. For
example, file like this
1234,"546,345",564
should be split into three pieces. But split function will make it four
pieces. Also if a cell in excel has data like
sgs"gdfgs"sdfsd
it is stored as
"sgs""gdfgs""sdfsd
I would like to see
sgs"gdfgs"sdfsd
when it is read into an string.
Thanks,
Andy
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!