On Tue, 04 Feb 2020 13:18:30 +0100, you wrote: >On 3 Dec 2019, at 16:10, Jannick wrote: > >> would it be possible to add to the csv extension the following parameter >> options (with syntax along the lines of): >> >> - sep=';': field separator character (different from default ',') >> - skip=N: skip the first N lines >> >> Both options would be very helpful for information of fixed format >> downloaded from information providers. > > Hi, those would be very useful enhancements.
I don't see the need, the feature is available in another form $ cat test.csv "a";"b" "c";"d" $ sqlite3 test.db \ "DROP TABLE IF EXISTS tbl1" \ ".mode csv" \ ".separator ;" \ ".import test.csv tbl1" \ ". mode column" \ ".headers on" \ "SELECT * FROM tbl1" a b ---------- ---------- c d -- Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
