5 ms·
If you live in a place where comma is the decimal separator, your CSV files will often use semicolon as the separator instead of comma. Will this tool cater for
by ochrist 3y ago
If you live in a place where comma is the decimal separator, your CSV files will often use semicolon as the separator instead of comma. Will this tool cater for that?
- wodenokoto 3y agoWhat do you mean cater to that? The point is you separate with a value that is not used within the fields. So decimal your numbers however you want.
- greenshackle2 3y agoThis is (nominally) a discussion about the csv-to-usv tool. They are asking if the csv-to-usv tool also accepts semi-colon delimited files as input. Have you maybe lost track of what post you're commenting under? (I believe the answer is no BTW, the tool only supports , as delimiter in its input.)
- ochrist 3y agoYes, this. Thank you. If I work with CSV files they are most often not comma-separated but semicolon-separated because of the numbers. An Excel installation localized for decimal comma would not read 'real' CSV files correct. If csv-to-usv cannot cater for this type of CSV files, it would not be usable in a large part of the world.
- greenshackle2 3y agoYeah they should add it. The tool is like 20 lines of Rust code. It's a thin wrapper around the csv Rust crate, which does support specifying alternative delimiters.
- jph 3y agoYes, the next release adds custom delimiters, e.t.a. one week.