Re: [Gretl-users] Input of csv data - does the German version work as intended?
El 02/02/16 a las 22:19, Alan G Isaac escribió:
Once again, a problem for data analysis arises when
someone insists that at **COMMA** separated values
file should be allowed to use commas for some other purpose.
Stick to the RFC and these problems go away:
https://tools.ietf.org/html/rfc4180
I understand why it was done, but I think the decision
to handle non-conforming files that claim to be CSV
was more politically correct than scientifically correct.
For CSV data exchange to be internationally feasible,
we need to stick to an international standard.
Cheers,
Alan Isaac
Look at https://en.wikipedia.org/wiki/Decimal_mark
It has a list ofcountries using decimal point, another list with
countries using decimal comma and a nice graph. Half the world uses the
decimal comma.
This strict CSV format cannot be an international standard. It is not
"internationally feasible" because of the ambiguity of the comma. Of
course, someone may pretend to change the official standards for more
than 60 countries, but I think it is easier to relax the CSV definition.
--
Ignacio Díaz-Emparanza
Departamento de Economía Aplicada III (Econometría y Estadística)
Universidad del País Vasco - Euskalherriko Unibertsitatea, UPV/EHU
Tfno: (+34) 94 601 3732
http://www.ehu.eus/ea3