search

mechatroner / vscode_rainbow_csv

🌈Rainbow CSV - VS Code extension: Highlight CSV and TSV files in different rainbow colors to make them more readable
MIT License
426 stars 51 forks source link

allow setting escape character #91

Open chrhon opened 3 years ago

chrhon commented 3 years ago

I have csv files which are using \ as an escape character so that they can embed the delimiter in a field (without quoting the fields). Example It's a bright\, sunny day as a value/column. This is also used for embedded newlines or carriage returnes. It would be great if rainbow CSV could handle this situation!

mechatroner commented 3 years ago

AFAIK this format is sometimes called "unix" csv dialect. I think it is not very frequently used these days. It is not impossible to add it but would take some effort. Another issue is that this will add another csv filetype to choose from (how can we name it BTW?) and that can be confusing for users who manually set filetypes in VSCode for their csv files.

chrhon commented 3 years ago

Interesting! This data I am working with right now is coming from a Redshift unload. I have seen it a few different times from different sources in the last year.