search

janisdd / vscode-edit-csv

vs code extension to edit csv files with an excel like table ui
MIT License
211 stars 30 forks source link

CSV data is split in an unexpected way. #141

Closed ruanluyu closed 6 months ago

ruanluyu commented 7 months ago

What OS?

Description

data

data_displayed

Expected behavior

Data should be split by comma.

Steps to reproduce

Download this csv data. map_extra.csv Open it via VSCode. Click "Edit csv" button.

janisdd commented 7 months ago

Well, I count 3 commas per line but 4 . per line --> . seems to be the better guess.

You can set the separator (delimiter) manually under Read options (then click on Reset data and apply read options).

janisdd commented 6 months ago

I guess this can be closed