The easy way out, if you have control over the delimited export file,
instead of using the "," as the delimiter, pick a character that you
KNOW is not going to be in any data, like "^". Otherwise, you need to
use a method that uses the double quotes to eliminate looking at the
delimiter within the data.
I have a external app that reads in a CSV correctly, and then spits
back out array to witango, but it isn't ready to put on my tools
site, just haven't had the time.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Jul 18, 2005, at 4:16 PM, Ken wrote:
Hi. I am building a Witango app to upload the contents of a huge csv
file (9 cols x 22000 rows). I am facing a few issues though.
1. A lot the cells in the csv are blank at times, producing 2 commas
together, that messes up my entire array.
2. the presence of commas in my data also creates an issue when trying
to separate individual pieces if data to be uploaded to the DB. DB
used is MySQL.
Any ideas, please. Example Code preferred.
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
