On Fri, 06 Mar 2009, Rich Shepard might have said:
> On Fri, 6 Mar 2009, Hans-Martin wrote:
>
> > It seems that there is no way to get rid of the embedded CR/LF without parse
> > the complete output.
>
>Use sed. That's what it's for.
>
> Rich
Or tr(1) if it's a single character.
Mike
Am Freitag, 6. März 2009 23:33:33 schrieb John Machin:
> On 7/03/2009 6:16 AM, Rich Shepard wrote:
> > On Fri, 6 Mar 2009, Hans-Martin wrote:
> >> It seems that there is no way to get rid of the embedded CR/LF without
> >> parse the complete output.
> >
> >Use sed. That's what it's for.
>
> Has
I use an excellent piece of software called AutoIT
(http://www.autoitscript.com). AutoIt is a very flexible easy to use
programming language which supports SQLite. I used it to write a csv
import program for SQLite. Took me 10 minutes. If you would like to
see the source as an example just say.
Ch
I use an excellent piece of software called AutoIT
(http://www.autoitscript.com). AutoIt is a very flexible easy to use
programming language which supports SQLite. I used it to write a csv
import program for SQLite. Took me 10 minutes. If you would like to
see the source as an example just say.
Ch
from my experience,
sed will read line by line, which is not good for the CSV file.(one field
can be on multiple lines).
why sqlite is not enhanced to handle fully the csv file format?
Cheers,
Sylvain
On Fri, Mar 6, 2009 at 11:33 PM, John Machin wrote:
> On 7/03/2009 6:16 AM, Rich Shepard wro
On 7/03/2009 6:16 AM, Rich Shepard wrote:
> On Fri, 6 Mar 2009, Hans-Martin wrote:
>
>> It seems that there is no way to get rid of the embedded CR/LF without parse
>> the complete output.
>
>Use sed. That's what it's for.
Has anyone considered that getting rid of the embedded CR/LF is
dest
On Fri, 6 Mar 2009, Hans-Martin wrote:
> It seems that there is no way to get rid of the embedded CR/LF without parse
> the complete output.
Use sed. That's what it's for.
Rich
--
Richard B. Shepard, Ph.D. | IntegrityCredibility
Applied Ecosystem Services, Inc.
Am Freitag, 6. März 2009 18:29:58 schrieb Griggs, Donald:
...
> Hi Hans,
Hi Donald!
>
> The sqlite command-line utility program does not have code in it to
> handle quoted strings containing the field separator (comma, in your
> case), nor does it expect the multi-line data.
>
> If you can have
al Message-
From: Hans-Martin Bundeshund [mailto:bundesh...@yahoo.de]
Sent: 06 March 2009 03:23
To: sqlite-users@sqlite.org
Subject: [sqlite] import a CSV-File
Hello to the List!
I started using SQLite (3.6.11) under WindowsXP and get confused using the
import-function. The import runs well
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Hans-Martin
Bundeshund
Sent: Friday, March 06, 2009 6:23 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] import a CSV-File
Hello to the List!
I started using SQLite (3.6.11
Hello to the List!
I started using SQLite (3.6.11) under WindowsXP and get confused using the
import-function. The import runs well with most lines, but i get an error when
it comes to following cases:
Case 1, the ',' between a string:
"Text of field1","Text of field2, not for field1"
after
11 matches
Mail list logo
