Handle CSV columns with square braces

Question

Handle CSV columns with square braces

simonw opened this issue 4 years ago · 3 comments

simonw commented 4 years ago

https://twitter.com/victorianoi/status/1438073122817810435

kudos the desktop app! Unfortunately, I have plenty of CSVs with columns using [] brackets for serializing arrays :/

Answer 1 · 2021-09-23T22:10:16.000Z

This is actually an error from sqlite-utils due to this issue:

simonw/sqlite-utils#86

Answer 2 · 2021-09-23T22:11:26.000Z

Oh wow, the bug I filed in Python about this has since been fixed! https://bugs.python.org/issue39652

Answer 3 · 2021-09-23T22:12:54.000Z

I think it's best to still keep [ and ] out of column names though. Transforming them into ( and ) seems reasonable - but should that happen here or in sqlite-utils? I think in sqlite-utils.