Peter, You forgot "far" as in "far beyond". Coping with non-standards and moving standards is something that is better left at a higher level, IMHO. I want to add more test and corner cases for things that are legitimate csv that we should make sure that we handle, properly, so when anyone thinks you have one, first check the "test cases folder", and if it is not in there, send it to me, please.
On Tue, Jun 14, 2016 at 9:33 AM, Peter TB Brett <[email protected]> wrote: > On 13/06/2016 12:45, Alex Tweedly wrote: > >> "into an array" .... in what way ? presumably a numerically indexed >> array. >> >> Perhaps a more general feature requests would be to extend the 'split' >> command, so that it would parse by Primary and Secondary delimiters into >> numerically indexed arrays ? (using a new optional keyword "completely" >> ... :-) >> >> e.g. split completely myVar by CR and TAB >> > > Hi Alex, > > I don't think an enhancement to the split command would be adequate for > correct parsing of a CSV file. > > For example, this is a single line of a valid CSV file, according to some > producers: > > > a,"b,c",d e > > The elements of the line are: "a", "b,c", "d" and "e". Obviously, this is > best handled by parsing into an array. > > Coping with the many subtle variants of CSV or TSV files is beyond what > can be realistically built into the engine, and having a library > specifically dedicated to good CSV file format support seems to me to be > the best way to deal with this. > > Peter > > -- > Dr Peter Brett <[email protected]> > LiveCode Technical Project Manager > > LiveCode 2016 Conference: https://livecode.com/edinburgh-2016/ > > _______________________________________________ > use-livecode mailing list > [email protected] > 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." _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
