On 26/09/2009 5:03 AM, Wilson, Ronald wrote: > > > Yeah. The clearest thing in the RFC is the ABNF grammar. However, even > that leaves out common cases like white space outside of quoted fields, > which most people would expect to be trimmed. Also, I think most people > would expect leading/trailing white space to be trimmed, even in > unquoted fields.
No, thanks. (1) Whitespace (space? CR? TAB? LF? NBSP??) outside of a quoted string is a violation of the writing rules for de-facto standard CSV. If the writer has used a different set of rules, then the reader should use that set of rules. (2) Trimming leading/trailing whitespace from unquoted fields? Excuse me, if CSV is the only format I can get data in, I don't want any wiseguy messing with it -- I want to see what exactly is in the data. Do XML parsers strip whitespace? Stripping leading/trailing whitespace (and compressing whitespace runs into a single space) should be /optional/ functionality to be applied (if desired) /after/ input, irrespective of the input format. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users