Unanswered

Change from dot to comma

Like (0) Share

Report

Posted on 22 Aug 2023 15:07:50 by speedhb90

I have to pass a variable with decimals from power automate desktop to a powershell script, the problem is that PAD works decimals with comma and powershell works decimals with point, what can I do before passing the variable with the decimal number to powershell to convert the comma into a point?

Thank you very much for your time.

All responses (3)

Answers (0)

Nived_Nambiar 17,982 Super User 2025 Season 2 on 23 Aug 2023 at 09:07:16

Like (0)

Report

Re: Change from dot to comma

Thanks for clarification @Agnius

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Agnius Bartninkas Most Valuable Professional on 23 Aug 2023 at 04:05:59

Like (1)

Report

Re: Change from dot to comma

The decimal separator that PAD uses depends on your regional settings on your machine. So, it might work for you, but might not work for someone else. PowerShell does expect a dot as a decimal separator regardless of the regional settings.

Using Replace text is the best bet here.
Nived_Nambiar 17,982 Super User 2025 Season 2 on 23 Aug 2023 at 03:11:30

Like (0)

Report

Re: Change from dot to comma

Hi @speedhb90

But PAD works with decimals with dot, see below

For converting the comma to dot, use replace action to replace the comma with dots like below

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌