Numeric strings returning with "," decimal seperator

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
Scones
Junior Coder
Posts: 32
Joined: Fri Jul 05, 2019 11:21 am

Numeric strings returning with "," decimal seperator

Post by Scones » Mon Mar 09, 2020 10:27 am

I'm located in europe, and my OS language is english.

When calculating strings, the result has "," as decimal separator, but Macro Scheduler can only handle "." seperators, it seems.

I found out using the ROUND function.

Is it intended?

I know i can just replace it with the right one, but i'm just curious about why this happens and if it is intentional.

Thanks in advance! :)

User avatar
Dorian (MJT support)
Automation Wizard
Posts: 1348
Joined: Sun Nov 03, 2002 3:19 am
Contact:

Re: Numeric strings returning with "," decimal seperator

Post by Dorian (MJT support) » Mon Mar 09, 2020 10:59 am

Hi Scones, did you know you can set these variables?

DECIMAL_SEPARATOR
THOUSAND_SEPARATOR
Yes, we have a Custom Scripting Service. Message me or go here

Scones
Junior Coder
Posts: 32
Joined: Fri Jul 05, 2019 11:21 am

Re: Numeric strings returning with "," decimal seperator

Post by Scones » Mon Mar 09, 2020 11:07 am

No i didn't know that :)

Might be a dumb question, but how do i do that?

Edit:
Nvm that question. Figured it out! Thanks very much for the tip!

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts