Import tsv: How to set delimiter to tabs?

104 views
Skip to first unread message

Susanne Meyer

unread,
Apr 22, 2017, 12:27:07 AM4/22/17
to phpliteadmin
Hi,

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

I'm using phpLiteAdmin v1.9.8-dev.

Jan Zumwalt

unread,
Apr 22, 2017, 9:05:14 PM4/22/17
to phpliteadmin
from the command line...

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

Susanne Meyer

unread,
May 2, 2017, 9:46:05 PM5/2/17
to phpliteadmin
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'.

Reply all
Reply to author
Forward
0 new messages