[sqlite] SQLite Shell Bug, Ignores Separators in Quotes Sometimes When Importing Data

2012-07-23 Thread Hayes, Michael - IS
I've got input data that uses double quotes to mean inches. So I have records with a single double quote character in a record. In some cases, SQLite is ignoring separators that are after the quotes. The documentation says that the separator will be honored even inside of quotes. (The

Re: [sqlite] SQLite Shell Bug, Ignores Separators in Quotes Sometimes When Importing Data

2012-07-23 Thread Richard Hipp
On Mon, Jul 23, 2012 at 8:37 AM, Hayes, Michael - IS michael.ha...@exelisinc.com wrote: The documentation says that the separator will be honored even inside of quotes. (The SQLite shell will always split fields on the separator character, no matter what comes before or after it. Quotes or

Re: [sqlite] SQLite Shell Bug, Ignores Separators in Quotes Sometimes When Importing Data

2012-07-23 Thread Black, Michael (IS)
, 2012 7:37 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] SQLite Shell Bug, Ignores Separators in Quotes Sometimes When Importing Data I've got input data that uses double quotes to mean inches. So I have records with a single double quote character in a record. In some cases, SQLite

Re: [sqlite] SQLite Shell Bug, Ignores Separators in Quotes Sometimes When Importing Data

2012-07-23 Thread Kevin Benson
On Mon, Jul 23, 2012 at 12:05 PM, Richard Hipp d...@sqlite.org wrote: On Mon, Jul 23, 2012 at 8:37 AM, Hayes, Michael - IS michael.ha...@exelisinc.com wrote: The documentation says that the separator will be honored even inside of quotes. (The SQLite shell will always split fields on

Re: [sqlite] SQLite Shell Bug, Ignores Separators in Quotes Sometimes When Importing Data

2012-07-23 Thread Richard Hipp
On Mon, Jul 23, 2012 at 2:28 PM, Kevin Benson kevin.m.ben...@gmail.comwrote: On Mon, Jul 23, 2012 at 12:05 PM, Richard Hipp d...@sqlite.org wrote: On Mon, Jul 23, 2012 at 8:37 AM, Hayes, Michael - IS michael.ha...@exelisinc.com wrote: The documentation says that the separator will

Re: [sqlite] SQLite Shell Bug, Ignores Separators in Quotes Sometimes When Importing Data

2012-07-23 Thread Black, Michael (IS)
[d...@sqlite.org] Sent: Monday, July 23, 2012 1:40 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] SQLite Shell Bug, Ignores Separators in Quotes Sometimes When Importing Data On Mon, Jul 23, 2012 at 2:28 PM, Kevin Benson kevin.m.ben...@gmail.comwrote: On Mon, Jul 23