Thanks Richard. I'm happy to say my handler parsed the extended test csv lines with flying colors. I'll try it along Alex's with some large datasets to see if there's any significant performance difference. By conicidence, I want the output form my handler to an array and I see Alex's does createw an array at one point so there may well be some benfits to switching over to his routine. Pete
On Wed, Mar 28, 2012 at 2:10 PM, Richard Gaskin <ambassa...@fourthworld.com>wrote: > Pete wrote: > > OK, so I know CSV files are not everyone's favorite subject but sometimes >> you have no control over how data reaches you! >> >> I have a handler in place that deals with the vagaries of CSV files, like >> returns, commas, and quotes in the data (did I miss any?) but it relies on >> a repeat loop looking at every character in the csv file. It seems to >> work >> just fine but I'm wondering if the collective knowledge of this list gas >> already come up with a more efficient solution. >> > > The article here outlines some of the many oddities about CSV, and > includes a handler from Alex Tweedly which thus far has been the most > efficient solution I've found: > > > CSV Must Die > A Plea to Introduce Sanity to the Software Development World > by Pledging to Never Write CSV Exporters > <http://www.fourthworld.com/**embassy/articles/csv-must-die.**html<http://www.fourthworld.com/embassy/articles/csv-must-die.html> > > > > -- > Richard Gaskin > Fourth World > LiveCode training and consulting: http://www.fourthworld.com > Webzine for LiveCode developers: http://www.LiveCodeJournal.com > LiveCode Journal blog: > http://LiveCodejournal.com/**blog.irv<http://LiveCodejournal.com/blog.irv> > > > ______________________________**_________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/**mailman/listinfo/use-livecode<http://lists.runrev.com/mailman/listinfo/use-livecode> > > -- Pete Molly's Revenge <http://www.mollysrevenge.com> _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
