CSV Files

[Pete]

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
<ambassador at 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 at 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>