Hi,
my below answer was wrong -- my approach produces a different output.
Am 26.06.2013 15:12, schrieb Nißl Reinhard:
Your sample [123, 9" Nail, ", Caliper, "set, up 5"", hold", 8 ] gives currently the
following column values (I used > and < to indicate the string bounderies, so that any white spaces are
noticeable):
>123< | > 9" Nail, "< | > Caliper< | > "set, up 5"", hold"< | > 8 <
Given that your input has been stripped by the leading spaces after a column
separator, or if the column separator has been defined as >, < you currently
get:
>123< | >9" Nail, "< | >Caliper< | >set, up 5", hold< | >8 <
With my approach you still get:
>123< | >9" Nail, "< | >Caliper< | >set, up 5", hold< | >8 <
You actually get:
>123< | >9" Nail< | >, Caliper, set< | >up 5""< | >hold"< | >8 <
So if that causes to much fuzz, then I'd like to suggest to make
the quotation character configurable. By setting it to '\0' for
example, my file could be read properly.
Bye.
--
Dipl.-Inform. (FH) Reinhard Nissl
mailto:rni...@gmx.de
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
