CSV again.

[Mike Kerner]

For everyone trying to get back up to speed on CSV, here's the closest
thing to a "Standard", RFC 4180:
https://tools.ietf.org/html/rfc4180

On Thu, Oct 15, 2015 at 8:34 PM, Peter Haworth <pete at lcsql.com> wrote:

> Right I remember that although not what the exact problem was.  In any
> case, csv4Tab has been working fine in my SQLiteAdmin program for at least
> a couple of years now, but I have no idea what flavor of csv files have
> been imported.
>
> Pete
> lcSQL Software <http://www.lcsql.com>
> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
>
> On Thu, Oct 15, 2015 at 5:24 PM, Alex Tweedly <alex at tweedly.net> wrote:
>
> > Richard et al.,
> >
> > sometime after that article, there was a further thread on the use-list.
> > Pete Haworth found a case not properly covered by the version on the
> > article, and I came up with a revised version (cutely called csv4Tab !! -
> > csv3Tab was an interim, deeply buggy attempt)
> >
> > (It's in
> > http://lists.runrev.com/pipermail/use-livecode/2012-May/172275.html )
> >
> > It *looks* from that thread (
> > http://lists.runrev.com/pipermail/use-livecode/2012-May/172191.html ) as
> > though this case had been discussed, and the re-write should properly
> > handle it - but I haven't yet had time to try it. My laptop has been
> > replaced in the meantime, and I can't find my test stack, and recreating
> it
> > and finding the test data is a bit too much for after 1am:-)
> >
> > So I'll try it tomorrow; hopefully csv4Tab() will already work for this
> > case. If it doesn't, we can try again :-)
> >
> > -- Alex.
> >
> > On 16/10/2015 00:34, Richard Gaskin wrote:
> >
> >> Mike Kerner wrote:
> >> > Alex, Richard, etc.
> >> >
> >> > What do we consider the latest version of the csv parser?  I think I
> >> > found a bug in Richard's CSV2Text code, and proposed changes, but he
> >> > wanted the discussion to go down over here, first.  Then I noticed
> >> > that csv4Text is out over here, which makes 2, I guess, a bit long in
> >> > the tooth.
> >>
> >> The version referred to here as "Richard's" is the famous Tweedly algo,
> >> in the middle of this page:
> >> <http://www.fourthworld.com/embassy/articles/csv-must-die.html>
> >>
> >> Alex came up with that after a a bunch of us here had a long discussion
> >> about the many variants of CSV running around, and how stupidly complex
> >> they are to parse (see the details in that article).
> >>
> >> Mike wrote me this afternoon letting me know that there's yet another
> >> exception that doesn't seem to be accounted for there:
> >>
> >>    "value","","value"
> >>
> >> I had thought we'd covered that in the earlier discussion, but perhaps
> >> not.
> >>
> >> So this seems like a good time to once again bring together the best
> >> minds in our community (are you listening Alex Tweedly, Geoff Canyon,
> Mark
> >> Weider, Dick Kreisel, and others?) to see if we can revisit CSV parsing
> and
> >> come up with a function that can parse it into tabs efficiently, while
> >> taking into account all of the really stupid exceptions that have crept
> >> into the world since that really stupid format was first popularized.
> >>
> >> When we're done I'll update the article, and add even more sarcastic
> >> comments about what a really dumb idea it was to have encouraged people
> to
> >> delimit text with a character so frequently appearing in text.
> >>
> >> --
> >>  Richard Gaskin
> >>  Fourth World Systems
> >>  Software Design and Development for the Desktop, Mobile, and the Web
> >>  ____________________________________________________________________
> >>  Ambassador at FourthWorld.com http://www.FourthWorld.com
> >>
> >>
> >> _______________________________________________
> >> 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
> >>
> >
> >
> > _______________________________________________
> > 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
> >
> _______________________________________________
> 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."