ERT INTO "CONFIGURATION" VALUES(5,'TEXT LINE 5 (72"""")',43721);
INSERT INTO "CONFIGURATION" VALUES(6,'TEXT LINE 6 (72"""")',43721);
INSERT INTO "CONFIGURATION" VALUES(7,'TEXT LINE 7 (72"""
On Mon, Jul 23, 2012 at 2:28 PM, Kevin Benson wrote:
> On Mon, Jul 23, 2012 at 12:05 PM, Richard Hipp 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
>
On Mon, Jul 23, 2012 at 12:05 PM, Richard Hipp 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 the
ONFIGURATION" VALUES(8,'TEXT LINE 8 (72")','43721S');
INSERT INTO "CONFIGURATION" VALUES(9,'TEXT LINE 9 (72")','43721S');
COMMIT;
sqlite> .import data.txt configuration
Error: data.txt line 10: expected 3 columns of data but found
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. Quo
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 SQL
6 matches
Mail list logo