csvToText Repository

[Mike Kerner]

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 <peter.brett at livecode.com>
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 <peter.brett at livecode.com>
> LiveCode Technical Project Manager
>
> LiveCode 2016 Conference: https://livecode.com/edinburgh-2016/
>
> _______________________________________________
> 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
>



-- 
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."