Comma as decimal point

Forum for discussing PicoScope version 6 (non-automotive version)
Post Reply
Karunen
Advanced User
Advanced User
Posts: 194
Joined: Thu Nov 21, 2013 9:22 am

Comma as decimal point

Post by Karunen »

Hi all,

If you are using a operating system with a language that uses a comma “,” as a decimal point “.” (French, German, Swedish, Italian, etc.),
then you will find that then using maths channels with decimal points you will have some issues.

This is because the software uses the operating system to break the numbers but it also use comma to separate variables when using function such as the high pass filter.
Maths Channel Wizard (High Pass filter Example)
Maths Channel Wizard (High Pass filter Example)
Unfortunately as this requires a major rewrite for the maths channel it may take a while before we are able to fix this issue.

While we are currently looking at this issue you can work around it by changing the decimal symbol of your language settings

Please go to Start > Control Panel > ...

Windows XP : Regional and Language Options>Customise

Windows Vista : Languages and Region > Customise this format.

Windows 7 : Region and Language > Additional settings

Windows 8 : Language> Change date, time or number formats > Additional Settings

And changing the Decimal symbol from a comma to a full stop.

Please accept my apologises for any inconvenience this may cause.

Kind Regards,
Karunen

Technical Specialist
Pico Technology

AndrewA
PICO STAFF
PICO STAFF
Posts: 401
Joined: Tue Oct 21, 2014 3:07 pm

Re: Comma as decimal point

Post by AndrewA »

Windows Regional settings are now supported in PicoScope 6.11.10. :)

So for most European languages ie French, German etc
You can now use a comma symbol ',' for the decimal place and a semicolon symbol ';' for the list separator, in maths channels.
Regards Andrew
Technical Specialist

ulf_l
Newbie
Posts: 0
Joined: Sat Sep 02, 2017 5:51 am

Re: Comma as decimal point

Post by ulf_l »

Hello

An other issue is the export of a serial decoded list into a csv-file. With a German windows-installation you get commas as separator and also a comma as "decimal point". So all my first exports are unusable, because all numbers with a comma as decimal point are separated into two rows. For example a -0.321 is stored in the csv-file as -0,321 and will be stored in a spreadsheet as RowA -0 and RowB 321.

It would be very useful if the character to separate the rows could be selected.

best regards,
Ulf

Martyn
Site Admin
Site Admin
Posts: 4491
Joined: Fri Jun 10, 2011 8:15 am
Location: St. Neots

Re: Comma as decimal point

Post by Martyn »

The development team are aware of this issue, and are currently looking at the language support options.
Martyn
Technical Support Manager

sbabic44
User
User
Posts: 3
Joined: Thu Nov 30, 2017 10:17 pm

Re: Comma as decimal point

Post by sbabic44 »

Hello!

Just to report that in software version: 6.13.2.3439 (beta) on Croatian locale the workaround with semicolon symbol ';' for the list separator, in maths channels doesn't work. We also have comma as a decimal point.

As far as CSV delimiter, good choice is semicolon. That way both decimal point or decimal comma are supported for numbers.

Regards.

Martyn
Site Admin
Site Admin
Posts: 4491
Joined: Fri Jun 10, 2011 8:15 am
Location: St. Neots

Re: Comma as decimal point

Post by Martyn »

Thanks for the feedback, I will feed it back to the development team.
Martyn
Technical Support Manager

scotty
Newbie
Posts: 0
Joined: Wed Feb 21, 2018 10:47 pm

Re: Comma as decimal point

Post by scotty »

Hi!
I have the same problem, so I can not analyse my data. Is there a solution available?

Martyn
Site Admin
Site Admin
Posts: 4491
Joined: Fri Jun 10, 2011 8:15 am
Location: St. Neots

Re: Comma as decimal point

Post by Martyn »

Is your issue with the filtering, or with csv export ?
Martyn
Technical Support Manager

vendra
Newbie
Posts: 0
Joined: Wed Oct 24, 2018 4:35 pm

Re: Comma as decimal point

Post by vendra »

I've the same issue. I'm exporting data to a .csv and the decimal char is confused as separator
I'm using Win10 and the separator in regional settings is set to ';'

How can I solve this ?

Walter

JPortici
Newbie
Posts: 0
Joined: Wed Dec 28, 2016 10:05 am

Re: Comma as decimal point

Post by JPortici »

In case you were wondering, the issue is not solved in the current software (6.13.15 - Just updated from 6.12.2667 because i had to throw away half an our of data because of this issue).

System Culture: Italian (comma as decimal point), Application Language English.
Csv export of protocol decoder window use comma as decimal point and comma as separator.

To find out the decimal point character is trivial, to ask the user which character to use for separation before the file is generated is even more trivial.

Also, some parts of the UI still use the system language and not the application language
In serial decoding table and export: Packet, Start Time, End Time.

Also if i use the numpad dot it's a dot and not a comma
Also if i use the dot in the trigger level it doesn't get recognized but the comma is (correct but meh). At least now the math channel Setup doesn't care if you use a dot or a comma and produce the expected output, which is nice.

Martyn
Site Admin
Site Admin
Posts: 4491
Joined: Fri Jun 10, 2011 8:15 am
Location: St. Neots

Re: Comma as decimal point

Post by Martyn »

This had been fixed in recent versions, but due to an unrelated change with csv exports it has resurfaced in the current release. The development team have made the necessary changes which will be rolled out in a new release once testing has been completed.
Martyn
Technical Support Manager

Mahima579
Newbie
Posts: 0
Joined: Fri Jul 26, 2019 6:38 am

Re: Comma as decimal point

Post by Mahima579 »

Thanks for updating the info.

DanielSchmid
Newbie
Posts: 0
Joined: Tue Nov 05, 2019 1:14 pm

Re: Comma as decimal point

Post by DanielSchmid »

Hi Support-Team,
I just have the same problem that the decimal places and the seperator are commas in the csv export. Are there any news when the problem will be fixed?

in january it was said that the problem should be solved with the next rollout?
The development team have made the necessary changes which will be rolled out in a new release once testing has been completed.
Thank you for your help!
regrads
Daniel Schmid

Post Reply