Reformat decimal value

[Brian_Henokh1 (Brian Henokh)]

Hello, anyone can help to solve this problem:

Ex:
1.111,00
2.222,00

Result:
1,111.00
2,222.00

I want to change comma separator to dot, and change the dot separator with the comma. Thanks in advance.

[mkankatala (Mahesh Kankatala)]

Hi @Brian_Henokh1

You can use the Replace Function in the expression,

- Assign -> Input = 1.111,00
- Assign -> Output = Cdec(Input.toString.Replace(".","@").Replace(",",".").Replace("@",",").toString)

Hope it helps!!

[ppr (Peter Preuss)]

@Brian_Henokh1

1.111,00

We highly recommend to do format conversions over CultureInfo handlings instead of doing on String Manipulation level. So we can control Side-effects

[singh_sumit (Sumit Singh Tariyal)]

Hie @Brian_Henokh1 use the replace function to replace comma with dot here are the screenshot

cheers Happy Automation