CODEWITHSUNDEEP
sqlitetabsdelimitedend-of-line
Meister1867
Meister1867

Reputation: 1

sqlite3 is not using end-of-line character when importing data

I have a tab-delimited file which I'm attempting to load into a table. The table has already been created and structured appropriately, the challenge is that SQLite3 is combining the last value on one row with the first value on the next row.

So for a file where the last line was SomeText, and the next line begins with 12345, the value imported is SomeText12345

Right now I'm using the following command:

.separator "\t";

.import MyFile.tsv MyTable

Any ideas how I can get the data to load while recognizing the end-of-line?

Upvotes: 0

Views: 306

Answers (1)

DinoCoderSaurus
DinoCoderSaurus

Reputation: 6520

I noticed the same problem. I've always suspected it had to do with the last value in a tab-separated file being a TEXT type. A little stack-sniffing turned up this post wherein the second answer says:

There is actually a dedicated mode for importing tab separated files:

sqlite> .mode tabs
sqlite> .import MyFile.tsv MyTable

Upvotes: 0

Related Questions