________________________________
From: Gert Van Assche <ger...@datamundi.be>
To: sqlite-users@sqlite.org
Sent: Wed, April 6, 2011 12:08:47 AM
Subject: [sqlite] read full txt file in one record
>Dear all,
>what would be the best way to read a full txt file into one record?
Until the experts reply to this, I'll try my cumbersome solution:
(I am no expert, but I tried to find a walk around which worked for me)
1. In every text file: replace (with a hex editor) the hex sequence "0D 0A"
(this is the CR + LF code ) with any other tow ASCII chars that you know for
sure they won't appear in the text files (i.e. "~~").
2. .import FILE TABLE
3. edit the database file with a hex editor, replacing "~~" with "0D 0A".
To test it:
SELECT rowid, your_text_data_column FROM your_table;
Hopes it helps .. somehow.
>Now, when I use
.import FILE TABLE
>I have every line on a record.
>I need all lines of one file on one record.
>The next record I need to fill with all lines of another file.
>thanks for your advise.
>Gert
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
