--skip option does not work correctly.
(1) By anonymous on 2021-10-28 03:13:03 [link]
When csv file 1st line is as below, --skip option does not work correctly. ,,,,,,,,,,,,,,,,,,,,,,,,,,, If I inserted some keyword for 1st comma,like anykeyword,,,,,,,,,,,,,,,,,,,,,,,,,,, This will work fine. Is this restriction of --skip option? or Starting with , is not allowed in csv format?
(2) By Gunter Hick (gunter_hick) on 2021-10-28 09:21:30 in reply to 1 [link]
Please be more specfic as to the meaning of "does not work correctly". Maybe stating what you expected and what you got my yield enough information to suggest a solution.
(3) By Gunter Hick (gunter_hick) on 2021-10-28 14:05:50 in reply to 1
If you want anonymous columns, just leave out the header line.
(4.1) By Harald Hanche-Olsen (hanche) on 2021-10-28 16:09:40 edited from 4.0 in reply to 1 [link]
I ran a little experiment. There is indeed an anomaly there: ``` ▶▶▶ .shell cat a.csv ,,, 1,2,4,8 42,,, ,9,3,1 ▶▶▶ create table a(x,y,z,w); ▶▶▶ .import -csv -skip 1 a.csv a a.csv:1: expected 4 columns but found 3 - filling the rest with NULL ▶▶▶ .nullvalue ø ▶▶▶ select * from a; x y z w -- - - - ø 1 2 4 8 42 9 3 1 ``` Notice that the first line got imported with three blanks and a null. If I add an extra character to the first line, either a comma or something else, the error goes away. Additionally, the error is still there if I replace the first line with `,a,b,c`. So it appears to be justy the initial comma that is problematic.
(5) By Larry Brasfield (larrybr) on 2021-10-28 19:53:31 in reply to 1 [link]
Thanks for reporting this. And thanks to Harald for making the problem clearer. This is fixed [here](https://sqlite.org/src/info/3aadbe17edc1efc7).
(6) By anonymous on 2021-10-29 08:43:34 in reply to 5 [link]
Thanks for reproducing the issue and fix. I appreciate your accomplishment.
(7) By anonymous on 2021-10-29 08:43:34 in reply to 5 [link]
Thanks for reproducing the issue and fix. I appreciate your accomplishment.