Patch #37621
open
Field separator in CSV export options
0%
Description
I would like to add a field separator option to the CVS export option form.
Background:
If I have set the language e.g. to English in my Redmine profile, the separator is taken from config/locales/en.yml (general_csv_separator) and it is comma. If I have installed e.g. German Microsoft Office and try to open such a CSV, it expects that the separator is semicolon. Unfortunately, Microsoft Office doesn't offer to choose the separator prior opening a CSV file and always uses the default value.
It is also related to #37581, where many translations have set general_csv_separator to different value than is expected in Microsoft Office.
Files
Updated by Go MAEDA about 1 year ago
Is the ability to select decimal separator unnecessary?
I think you need to change the decimal separator to ";" when you change the field separator to ",".
Updated by Karel Pičman about 1 year ago
No, you needn't. When the decimal separator is comma, values containing comma are enclosed in apostrophes.
...2022-09-12,"","2,50","2,50",0,2022-09-12 07:37...