Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to handle tab delimited csv file? #261

Open
metawops opened this issue Jul 24, 2020 · 6 comments
Open

How to handle tab delimited csv file? #261

metawops opened this issue Jul 24, 2020 · 6 comments
Labels
enhancement New feature or request good first issue Good for newcomers help wanted Extra attention is needed

Comments

@metawops
Copy link

I have a csv file with the tab character als a delimiter.
I'm in VSCode and have the file open.
Extensions like Rainbow CSV have no problem detecting the columns.
But SandDance doesn't recognize my columns. It just sees one single column.
How can I tell SandDance (the VSCode extension) to use the tab character as a delimiter?

@danmarshall danmarshall added enhancement New feature or request good first issue Good for newcomers help wanted Extra attention is needed labels Jul 24, 2020
@danmarshall
Copy link
Contributor

danmarshall commented Jul 24, 2020

Hi @metawops, can you try changing the file extension to tsv to see if it works? Typically .csv files use a comma, and .tsv files use a tab as delimiters.

We could add features to do better column detection, as well as handle semicolon and international number formats which use a comma as a decimal.

@metawops
Copy link
Author

Hi @metawops, can you try changing the file extension to tsv to see if it works? Typically .csv files use a comma, and .tsv files use a tab as delimiters.

That actually worked. However, Windows Explorer now doesn’t show the Excel document icon anymore because Excel apparently isn’t connected with .tsv files.
Anyway, thanks for the hint!

We could add features to do better column detection, as well as handle semicolon and international number formats which use a comma as a decimal.

I’d appreciate that. Always a hassle working with decimal points/commas in number, date formats, commas in strings that are not field separators etc.pp.

@Para7etamol
Copy link

Quick fix could be to make the column separator an editable setting ;-)

Need semicolon as separator, because comma is the decimal separator in german!

@Runekeon
Copy link

Runekeon commented May 19, 2022

I agree working with nested json in columns so using ~ for separator. The ~ never shows up in the data but almost any other character could. Most commonly csv files use a comm but the c can stand for character separated file. So Allowing separation by a selected character helps a lot, when data contains embedded commas.

@hammerandpick
Copy link

Quick fix could be to make the column separator an editable setting ;-)

Need semicolon as separator, because comma is the decimal separator in german!

Same here, this problem is due to the switched "." and "," within numbers. I raised this as idea #606 before checking for this issue.

@verajosemanuel
Copy link

same here. Comma separator is for decimals in spanish, so unable to use SandDance in vscode

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request good first issue Good for newcomers help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

6 participants