Forum Discussion
Helper I. as thousand separator = wrong
hi there,
i think you can change the locale to English (United States).
or you can try replacing the dot (.) with a comma (,) before converting the values to decimal numbers.
this should do the trick.
hope this works for you,
radpir
Super UserCan you please post your sample file if possible to see exactly what is happning behind the scene.
Helper IOk.
The data files (many sensor data) is like,
Date Time,Battery[V],Temperature,Humidity, An_1,An_2,DIG_010,DIG_010_T,DIG_011,DIG_011_T,DIG_012,DIG_012_T,DIG_013,DIG_013_T,DIG_014,DIG_014_T,
2016/11/03 14:03:50,12.1,19.3,N.C.,-36.849,399.703,0.15596,20.84561,-0.06102,20.68701,0.08798,20.92682,0.11082,20.77658,0.14069,20.78555,
After change the type to decimal nummber (I can not export data, can you see the image below?),
(date_Time), 122, 193, ..., -36849, 399703, 15596, -6102, 2068701, 8798, 2092682, 11082 ...
I can think to change the settning from "Swedish" to "English". But which language is suitble for me?
Regards.
- BhaveshPatel
You can see in my screenshot that I don't have any problem converting your sample data in decimal numbers.
I have splitted the column by comma separator and converted the data type of resulting columns into decimal numbers.
- radpir
Resolver II
hi there,
i think you can change the locale to English (United States).
or you can try replacing the dot (.) with a comma (,) before converting the values to decimal numbers.
this should do the trick.
hope this works for you,
radpir
- James1965