Hi. I building a coldfusion 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 prsence of commas in my data also creates an issue when trying to sparate individual pieces if data to be uploaded to the DB. Any ideas, please. Example Code preferred. - Ken ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212173 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54