At this point, finding a function that does the task at all -- reliably and taking into account most of the csv malformations we can anticipate -- would be a start. So far nothing has been unbreakable. Once we find an algorithm that does the job, we can focus on speeding it up.
That said, I don't know that my solution is optimized for speed very well. It takes 4-5 seconds to process a 986 record file. On an old slow machine, a 2008 MacBook 2.1 GHz Intel Core Duo, but still…. -- Peter Peter M. Brigham pmb...@gmail.com http://home.comcast.net/~pmbrig On Oct 17, 2015, at 10:05 PM, Mike Kerner wrote: > The other thing that we are going to be interested in is finding the > fastest function that performs the task. > > On Sat, Oct 17, 2015 at 10:04 PM, Mike Kerner <mikeker...@roadrunner.com> > wrote: > >> I think that item is odd. Quotes are, if memory serves, only supposed to >> appear if they are double-quoted. Between "f" and "g" you have three >> quotes, and between "g" and "h" you only have one. I believe that is not a >> correct csv format. >> >> On Sat, Oct 17, 2015 at 9:24 PM, Peter M. Brigham <pmb...@gmail.com> >> wrote: >> >>> On Oct 17, 2015, at 8:47 PM, Alex Tweedly wrote: >>> >>>> Also, I think (i.e. I haven't yet run the code, since I don't have >>> offsets() available) there is another mis-formed case you don't properly >>> detect : >>>> a,b,c,"def"""g"h",i,j,k >>> >>> if I put this as one of the lines of my CSV data, it gets sorted into the >>> array properly. I think. That is, the 4th item of the line is >>> >>> "def"""g"h" >>> >>> Do you get the same result? >>> >>> -- Peter >>> >>> Peter M. Brigham >>> pmb...@gmail.com >>> http://home.comcast.net/~pmbrig >>> >>> >>> >>> _______________________________________________ >>> 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 >>> >> >> >> >> -- >> On the first day, God created the heavens and the Earth >> On the second day, God created the oceans. >> On the third day, God put the animals on hold for a few hours, >> and did a little diving. >> And God said, "This is good." >> > > > > -- > On the first day, God created the heavens and the Earth > On the second day, God created the oceans. > On the third day, God put the animals on hold for a few hours, > and did a little diving. > And God said, "This is good." > _______________________________________________ > 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 _______________________________________________ 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
