If using a Jar file on your CF server is an options, you might also want to take a look at the open-source Java libraries for CV Parsing and Writing at http://ostermiller.org/utils/CSV.html. The parse() function in CSVParser throws an IOException if there is an error parsing.
I use the ExcelCSVPrinter to write Excel compatible CSV's that users can download. It is quite handy at taking care of many of the nuances of CSV, and the code to create the CSV is much cleaner than the equivalent CF code. Jon On Thu, 02 Dec 2004 20:38:34 -0400, Brant Winter <[EMAIL PROTECTED]> wrote: > That is how I have ended up doing it. > > I created a function to check each field in each row, and create an array of > structures. Each array element represents a row in the CSV, if there is an > error it populates the structure in the array element that corresponds to the > curren trow of the CSV file. Later I check for structures in the array that > are not empty and generate an error report for the failed rows, and suck the > rest into the DB. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186149 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
