mithrandie / csvq

SQL-like query language for csv
https://mithrandie.github.io/csvq
MIT License
1.51k stars 63 forks source link

Add --lazy-quotes option to be on par with go package encoding/csv reader #119

Open colbee1 opened 5 months ago

colbee1 commented 5 months ago

With the following CSV

"Column1";"Column2";"Column3"
"27GN800P-B";"TV 27" to 31"";14/03/24

csvq failed to parse file with error: 'unexpected " in field'.

Parsing the same file with native go package "encoding/csv" succeed using option reader.LazyQuotes = true If LazyQuotes is true, a quote may appear in an unquoted field and a non-doubled quote may appear in a quoted field.