mithrandie/csvq-driver

Config the CSV delimiter

mazux opened this issue · 1 comments

mazux commented

I'm unable to parse a ; delimiter csv files

Any idea how to do so?
I was thinking of creating a PR in which I add another param to the connection string to specify the CSV delimiter

mithrandie commented

Can you try this statement?

db.QueryRowContext(ctx, "SET @@DELIMITER TO ';'; SELECT * FROM `foo.csv`")

cf. https://mithrandie.github.io/csvq/reference/flag.html

  • 👍1