Actually, this might not work in the following scenario where you have an address field like this:
"123 Laurel Lane Apt. 3, Chicago, IL"
Bummer.
At 10:59 AM 4/15/2004, you wrote:
You could also do the following (tedious) replacements before the final tokenize step:
replace ,1 with ,"1 replace ,2 with ,"2 and so on...
replace 1, with 1", replace 2, with 2", and so on...
Yuck, but it would work.
Stefan
At 10:53 AM 4/15/2004, you wrote:Maybe you can request that they are formatted correctly from your source?
Stefan
At 10:30 AM 4/15/2004, you wrote:> A properly formatted csv file has double quotes around all fields,
Damn, these files don't have quotes around the numeric value fields.
Wayne
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
===================================================== Database WebWorks: Dynamic web sites through database integration http://www.DatabaseWebWorks.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
===================================================== Database WebWorks: Dynamic web sites through database integration http://www.DatabaseWebWorks.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
=====================================================
Database WebWorks: Dynamic web sites through database integration
http://www.DatabaseWebWorks.com
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf