Thanks Igor. I will look for that. 2013/2/21 Igor Tandetnik <i...@tandetnik.org>
> On 2/21/2013 5:34 AM, Gert Van Assche wrote: > >> I have to import text files into an SQLite table. >> The txt files are plain text in UTF-8. They don't contain tabs and the >> line >> ending is CRLF. >> >> One line in the TXT should become one record in the table. >> >> CREATE TABLE Source (Segments); >> .import 'test.txt >> <http://www.datamundi.be/test.**txt<http://www.datamundi.be/test.txt>>' >> Source >> >> SELECT count(*) FROM Source; >> >> The source text contains 156659 lines but the imported table contains only >> 65561 records. >> > > If you are on Windows, check that the file doesn't happen to contain a > byte with the code of 26 (aka 0x1A aka ^Z). Such a byte is treated as > end-of-file indicator in text files. > -- > Igor Tandetnik > > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<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
