Automatic detection of decimal/thousand seperators

[vergauwenthomas]

Problem:
@spuynen cannot use coordinates because the latitude is incorrectly read in (5095584 instead of 50.95584).

What is going on:
@spuynen found that . is used for both thousands as decimal splitter. He uses windows and excel. Formatting (without opening) to UTF8 did not fix the issue.

Solution:
Tricky, since this is specific to OS (and even laptop language settings i think). Further research into this topic is needed.

[vergauwenthomas]

Here is how excel saves it:

ID;Vlinder;lon;lat;stad;benaming;school;sponsor;Network
31;vlinder75;5495661;5096518;Genk;Ref;nvt;HBS;Vlinder
32;vlinder76;5499444;5096486;Genk;Garden;nvt;HBS;Vlinder
33;vlinder77;5499120;5096503;Genk;Playground;nvt;HBS;Vlinder
34;vlinder78;5499504;5096498;Genk;Tree;nvt;HBS;Vlinder

[vergauwenthomas]

One solution can be to include the reading of excel files directly, in the hope that the formatting of the numeric values are in the metadata.