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

Change CSV delimiter and quotes #130

Open
kliclick opened this issue Oct 16, 2020 · 1 comment
Open

Change CSV delimiter and quotes #130

kliclick opened this issue Oct 16, 2020 · 1 comment
Labels

Comments

@kliclick
Copy link

Hi, maybe it could be nice to change the CSV delimiters. The comma delimiter is often used in names, notes, titles, etc. This leads to bad structured csv files. The same observation about double quotes.
For me the best format is a tab separated file without quotes because there's almost no confusion with such characters in the fileds contents.
Maybe an improvement is to have 2 new options paramaters for the xml to csv export:

  1. Delimiter (tab, comma, semicolon, maybe user-defined)
  2. Quotes (single quotes, double quotes, none)
@philipmat
Copy link
Owner

Not opposed to having alternate separators, but I want to correct this part:

The comma delimiter is often used in names, notes, titles, etc. This leads to bad structured csv files. The same observation about double quotes.

CSV format addresses this concern: if any fields contain comma, they're encapsulated in quotes; if any field contains quotes, then that field is also encapsulated in quotes and the quotes inside are doubled. Similar for new lines.

As far as I know, discogsxml2db produces well-formatted CSV files. If you encounter a situation where that does not hold true, please file a bug report.

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

No branches or pull requests

2 participants