On 6/26/2013 11:21 AM, RSmith wrote:
I meant if a real csv interpreter conforming to  RFC4180 were to read the 
garbage I posted, it would come up with the
result specified.

How do you know what a standard-conforming interpreter would do when presented with input that's invalid under that standard? The standard only describes the meaning of valid input, naturally. What exactly is your claim based on?

I would imagine that most (well-written, not otherwise buggy) CSV interpreters agree in their interpretation of RFC4180-conforming input; RFC4180 describes a pretty strict subset of what's found in the wild. It's precisely in their handling of non-conforming input that CSV interpreters differ.

Having done this many times I already know the answer to his problem,
it's real easy, a simple command-line tool to make his weird format into
a SQLite table - would take a few minutes to make and save him a lot of
trouble - I even offered help doing it - but he is intent on arguing
that SQLite should change and do it "smarter" - (which is his right) -
and now I'm trying to show why it isn't smarter in the hope of finding a
resolve.

I totally agree.
--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to