A client of mine insists on providing database updates in CSV format. And of
course some of the fields contain commas within the text. All the text
fields are double quoted.
I've written a bunch of assigns that replace ", and ," with [col] and then
remove all remaining " and it works just fine. Of course it would fail if
there were two number fields next to each other but that isn't the case.
This problem is as old as computers and must have been dealt with many
times. What sort of methods and procedures are people using?
BTW, this is an automated procedure run by a CRON job.
Wayne Irvine
Byte Services Pty Ltd
http://www.byteserve.com.au/
[EMAIL PROTECTED]
Ph 02 9960 6099 Mob 0409 960 609 Fax 02 9960 6088
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
