Opened 10 years ago
Last modified 7 years ago
#3227 accepted enhancement
Make possible to change the csv file delimiter char and quote char (for input file and output file) — at Version 4
Reported by: | Adeel Asghar | Owned by: | Adrian Pop |
---|---|---|---|
Priority: | high | Milestone: | Future |
Component: | Run-time | Version: | trunk |
Keywords: | Cc: | Manfred.Rode@…, Lennart Ochel, Vitalij Ruge |
Description (last modified by )
Currently there seems to be 4 separate implementations for the csv files:
- input file externalInput.csv uses space as a delimiter
- input file for optimization uses space as a delimiter
- writing output results to the csv file is done using delimiter ","
- reading results from the results file uses comma as delimiter (libcsv.c)
All these 4 different implementations should be based on libcsv.c which is the most configurable and one should be able to set the csv delimiter char and the quote char from command line.
Change History (4)
comment:1 by , 10 years ago
comment:2 by , 10 years ago
We agree. We had a discussion about it today and I'll see about adding a -csvDelimiter='char' so that we can configure it from command line.
comment:3 by , 10 years ago
Cc: | added |
---|
Tab appears to be the best default delimiter, because it is unique in the whole world.
Spaces might easily be used inside names or date/time formats. Comma is used as decimal delimiter in some countries; as thousands seperator in others. Semicolon is not understood by people who prefer a comma as delimiter ...
With tab delimiters one can even copy/paste the file into an Excel spreadsheet, because this increments the cell without any custom format settings.
comment:4 by , 10 years ago
Cc: | added |
---|---|
Description: | modified (diff) |
Status: | new → accepted |
Summary: | Change the external input csv file delimiter → Make possible to change the csv file delimiter char and quote char (for input file and output file) |
Tabs are also often used as a delimiter, so it would be great if this would be configurable/flexible.