All this talk of replacing multiple commas with pipes, then replacing pipes and so on, though clever and helpful is problematic, cumbersome and even comical for a mature product like SQLite.
On 13/09/2010, at 9:53 PM, Simon Slavin wrote: > This is true. You are right. You might argue that it's a bug. I'd absolutely argue that it's a bug or at least an incomplete feature. This issue has arisen so often on this list that I can't understand why CSV isn't fully implemented yet. Some have argued here in the past that CSV isn't properly defined to which others of us have argued that it is effectively universally accepted that: 1. Anything within quotes "like, this", is one value and should import into one column. 2. Two quotes "" within quotes should import as one quote. 3. Outside quotes, a new line defines a new row. 4. Outside quotes, a comma defines a new column. Please make it so. Thanks, Tom BareFeetWare -- Comparison of SQLite GUI tools: http://www.barefeetware.com/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
