Import tsv: How to set delimiter to tabs?

[Susanne Meyer]

Hi,

how to import a tsv file (tab separated values) to a sqlite3 table?

I'm using phpLiteAdmin v1.9.8-dev.

[Jan Zumwalt]

from the command line...

sqlite> .separator "\t" ---IMPORTANT! should be in double quotes
sqlite> .import afile.csv tablename-to-import-to

[Susanne Meyer]

Hi Jan,

thank you for your answer!

Is your code done outside of phpLiteAdmin? If so I already knew how this is done one sqlite3 command prompt. I thought there might be a way to do this inside of phpLiteAdmin? For example in the phpLiteAdmin interface tab 'import'.