On Tue, 2 Feb 2016, Wingenroth, Thorsten wrote:
Hi Allin,
sorry, I wanted to attach them...
Thanks, Thorsten. For reference, these files use ',' and decimal
separator and ';' as field delimiter (OK). They also use '.' as
thousands marker and as the delimiter within daily dates (and into the
bargain the dates are reversed). So for example:
<csv>
date;Erster;Hoch;Tief;Schlusskurs;Stuecke;Volumen
23.02.2015;71,16;71,24;70,6;70,91;172.975;12.251.361
20.02.2015;70,55;70,92;70,22;70,62;752.159;53.136.228
19.02.2015;70,74;71,06;69,93;70,73;576.821;40.735.744
...
</csv>
Gretl running in English gets everything right automatically, but the
importation fails when running in German -- in fact, in any locale
that uses ',' as decimal character and with "Use locale setting for
decimal point" selected in gretl's Preferences.
A workaround for opening such files in German is to deselect "Use
local setting for decimal point". However, it should work either way;
we'll see what we can do about that. The problem seems to lie in the
handling of the thousands separator: if I delete those '.' characters
from one of your files gretl reads it fine even when in decimal comma
mode.
Allin