vscode-data-preview icon indicating copy to clipboard operation
vscode-data-preview copied to clipboard

Published 20 hours ago • verified publisher icon RandomFractals

csv separator

Open sank96 opened this issue 4 years ago • 3 comments

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?

sank96 avatar Mar 01 '21 19:03 sank96

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.

IainMNorman avatar Mar 18 '21 11:03 IainMNorman

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

LeMapper avatar Dec 13 '21 10:12 LeMapper

@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.

RandomFractals avatar Dec 13 '21 16:12 RandomFractals