Import sqlite3 file

Question

is there a way to import a file into a table with a separator ":"?

For example, I have a test.txt file with

value1:result1
value2:result2

want to use something like this in the CLI:

sqlite> .import test.txt table

and in the end I would:

+--------------+
|value1|result1|
+------+-------+
|value2|result2|
+------+-------+

Answer 1

use .separator :

.separator STRING      Change separator used by output mode and .import

Here .

Answer 2

If you use .help, you may notice something interesting:

sqlite> .help
...
.help                  Show this message
.import FILE TABLE     Import data from FILE into TABLE
...
.separator STRING      Change separator used by output mode and .import
...

So that .importmay be what you are looking for; -)