SQLite Forum

Feature request: .import based on column
I suggest you write a utility program that converts your data into RFC-4180 CSV.
You could probably do this as a script in Python or TCL.  Suppose the program
is called "column-to-csv" and works like this:

> ~~~~
column-to-csv 1,15,35 file >file.csv

Once you have such a converter program, then you can import into SQLite using
a command-line like this:

> ~~~~
.import -csv '|column-to-csv 1,15,35 file' table