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

as with everything CSV you need a way to define delimiters #2

Open
speedupmate opened this issue Dec 30, 2021 · 2 comments
Open

as with everything CSV you need a way to define delimiters #2

speedupmate opened this issue Dec 30, 2021 · 2 comments

Comments

@speedupmate
Copy link

Currently theres no info on what delimiters it supports and for sure it does no support a semicolon (;) and also option to skip n lines from top is often important as those can contain other information like column names, headers etc .

A CSV file stores data in rows and the values in each row is separated with a separator, also known as a delimiter. The most common delimiters are: a comma (,), a semicolon (;), a tab (\t), a space ( ) and a pipe (|). But theoretically anything can be a delimiter as long as it is consistent.

@mwenge
Copy link
Owner

mwenge commented Dec 31, 2021

I've tried to make it as tolerant as possible without trying to cater for every permutation of CSV, because there are so many. Given a file with a 'csv' suffix it will assume it is comma separated (and ignore any leading lines). Given a *.txt file it will attempt to guess the delimiter based on the first x rows. It doesn't support space as a delimiter.

@drobin04
Copy link

drobin04 commented Mar 6, 2023

Is there a way to tell it that the delimeter is a colon?
I've got a file with two values on each line separated by a colon, but can't get it to load.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants