Also, geneticists have been forced to rename certain gene names because Excel messed them up[0].
It would be nice if this standard would be generally accepted. This standard is from 2005 and it is pretty clear that it is not universally used.
[0] https://www.theregister.com/2020/08/06/excel_gene_names/
Which is an inevitability for anything that's been a dependency for long enough.
Either you admit that things have to change and sometimes shit that's been secretly broken for years will have to change too, or you give in to the shit and admit that you can never solve any problems that made it to production.
Both answers suck, but one is a lot more suck so I choose the "fix it anyways and if something else turns out to have depended on the brokeness then add that to the list of shit to fix" approach whenever possible.
Examples:
- double quotes in text fields
- using the wrong decimal separator, should it be "," or "."
- using the wrong column separator, should be "," or ";"
> This standard is from 2005 and it is pretty clear that it is not universally used.
Unfortunately a lot of non-conforming software can't change or they risk compatibility problems with old versions of themselves. 2005 is relatively recent in the history of CSV files.