Is there a way to delete a trailing unnamed column?

[davidpellerin]

Hi 👋 Just wondering if there is a way to delete a blank column caused by a trailing comma in a CSV on each line?

I figure I could use sed and give it a name, but i'd rather not modify a vendor supplied file if I don't have to.

[ondohotola]

ALTER TABLE, perhaps? but why bother? Just don’t SELECT it. el — Sent from Dr Lisse’s iPhone

…

On 23. Jul 2021, 23:57 +0200, David Pellerin ***@***.***>, wrote: Hi 👋 Just wondering if there is a way to delete a blank column caused by a trailing comma in a CSV on each line? I figure I could use sed and give it a name, but i'd rather not modify a vendor supplied file if I don't have to. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe.

[kpym]

You can use t.1 to access the 1st column of the table t. So you can use alter table to drop the 1st column.

For example if test.csv is the following file

> cat test.csv
,A,B,C
,1,2,3
,4,5,6

then you can for example drop the first column like this:

> cat test.csv | csvq -f csv -q  "alter table stdin drop stdin.1; select * from stdin;"
A,B,C
1,2,3
4,5,6