Re: csv extension/feature requests: new options for field separator different from default ', ' and skip=N to skip first N lines
Kees Nuyt <k.nuyt-RSh1/+X/PmFmR6Xm/[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users