On Tuesday, 21 May, 2019 07:55, Richard Hipp <d...@sqlite.org> wrote:
>On 5/21/19, Patrick Sherrill <patr...@michael-clarke.com> wrote: >> I don’t know about ‘valid’ csv, it has been a moving target for >>decades. >> White space as far as my recollection should not be considered in >>parsing a csv. >I'm going by RFC 4180. https://tools.ietf.org/html/rfc4180. On page >2 it says: "Spaces are considered part of a field and should not be >ignored." and also the RFC also says in section 5 Each field may or may not be enclosed in double quotes (however some programs, such as Microsoft Excel, do not use double quotes at all). If fields are not enclosed with double quotes, then double quotes may not appear inside the fields. So, since white space is not ignored and the first character of the field is not a quote (it is a space), then the quote inside the field is an error and should presumably toss some sort of a parse exception ... --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
