RandomFractals / vscode-data-preview

Data Preview 🈸 extension for importing 📤 viewing 🔎 slicing 🔪 dicing 🎲 charting 📊 & exporting 📥 large JSON array/config, YAML, Apache Arrow, Avro, Parquet & Excel data files
https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.vscode-data-preview
Apache License 2.0
550 stars 59 forks source link

csv separator #254

Open sank96 opened 3 years ago

sank96 commented 3 years ago

Hi, I have a csv file that use ; symbol as separator. Is it possible to set the semi column as separator instead of the comma?

IainMNorman commented 3 years ago

And I have many that use a tilde ~ as a separator.

Other extensions have a setting for an array of separators. That would be cool.

LeMapper commented 2 years ago

I second this. Semicolons e.g. are in wide use outside the US. Other tools with less or different functionality provide the ability to choose the separator. https://marketplace.visualstudio.com/items?itemName=mechatroner.rainbow-csv https://marketplace.visualstudio.com/items?itemName=janisdd.vscode-edit-csv

As far as I see it, Data Preview works fine if you open the file directly with "Preview data". But it fails to recognize the columns, if you use "Preview Data On Side". grafik

RandomFractals commented 2 years ago

@LeMapper Rainbow CSV is great. I use it myself.

You can also try Excel Viewer if this Data Preview extension doesn't work with your data files, or you want finer control over value separators and data formatting.

I am working on new vscode extension that will address some of those shortcomings in Data preview:

https://github.com/RandomFractals/tabular-data-viewer

Until then, I don't think I will find the time to mend and patch some of the most recent requests in this repo.

Thank you for your feedback and note about data on side. It could be related to #250.