q
q copied to clipboard
Output quoting doesn't work with newlines
Example CSV:
columnOne,columnTwo,columnThree
testA,one one,aaa
testB,"two
two",bbb
testC,"three, three",ccc
Running:
$ q -HOd, "select * from test.csv"
columnOne,columnTwo,columnThree
testA,one one,aaa
testB,two
two,bbb
testC,"three, three",ccc
So testA and testC quote correctly, but testB with its newline doesn't.
You're right. It seems that the default "minimal" output wrapping format does not cover newlines...
You can use "-W all" in the mean time in order to get coherent output. I'll make sure to fix this as soon as possible.
Harel
@maxharlow Hi, can you please confirm that the workaround works for you? or is it?
Yes that works -- thank you