How to adjust decimals (0.0.0) into 2 decimal places (0.00)

Help Activities
, ,
1

Greeting,

I want to convert from 0.0.0.0 to 0.00 due to PDF document was written “0,0.00” but UIPath read as “0.0.00”. So, my method was to use excel as converter and I can’t find solution for it. Really appreciate if got solution formula on excel or UIPath using assign activities. Also appreciate if provide me in easy terms because I just learn to adapt this.

image

2

Hi,

Can you try the following expression?

System.Text.RegularExpressions.Regex.Replace(yourString,"\.(?!\d+$)","")

This will return 18183339.54 if yourString is 18.183.339.54

Regards,

3

try this @DTECH
test.xaml (7.0 KB)
image

1 Like
4

Thanks man, it works flawless. Appreciate.

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.