Wrong Conversion of csv

Support
1

Hi,

I have a problem with reading and converting a csv file.
Given is a simplified csv file as shown below (just a field and a corresponding value):
See also attached filewrong conversion.csv (166 Bytes)
grafik

As you can see, the file has a comma as decimal separator, the point is the thousands separator.

Case 1:
The settings in the Import action are:

grafik
grafik.png448×539 14.7 KB

The result in easymorph is:
grafik
The values (of field “Value”) are automatically converted to numbers except the field with the thousands separator. At the numbers the decimal separator has changed to a point, but for the field with a thousands separator, the behavious is as-it-was (comma as decimal separator, point as thousands separator).

Case 2:
As a workaround, I tried to import everything as text (in the advanced options):
grafik

grafik
In this case, I have the option to remove all thousands separators and replace all commas with points. Then, it would be possible to convert thevalue to a number, but I think, there should be an easier way to handle.

In my opinion, the easiest way would be to get the regional settings of Windows.
Is there a possibility to treat the separators as in adjusted in the Windows settings?

2

great post, have the same problem over and over again. Data conversion (date, numbers …) cannot be done generically at the moment :frowning:

I think, first thousands separators would be really important.
Import allways at Text and Change all other Types can not be the way

3

Same type of problem with web request:
grafik
Please have a look at the last number per line:
“25,13”
“1.500”
Decimal separator is ‘,’, thousands separator is ‘.’ in both cases.

In the next step, I split into columns:

grafik
grafik.png1004×279 11.2 KB

As you can see, the decimal separator switches from ‘,’ to ‘.’, but the thousands separator remains as ‘.’.

Are there plans for a standard handling of separators? I guess that the actual behaviour causes wrong transformation.

4

We will add an option for thousand separator in a future release. Not in v4.5 but a release after it.

2 Likes