Regex for numeric variable

[alvin.c.apostol26 (Alvin)]

Hi UiPath,

I need help with my problem.

I extracted a string value using get text activity below:

2,604,000.00 SGD

let say I want only the 2,604,000.00 without the SGD how can i do that?

and if possible convert it to this format:

2604000.00

Thanks in advance!

[Gokul001 (Gokul Balaji)]

Hi @alvin.c.apostol26

How about this expression?

System.Text.RegularExpressions.Regex.Match(YourString,"\d.+(?=\sSGD)").Tostring

Regards
Gokul

[Gokul001 (Gokul Balaji)]

[Gangadhar_Athili]

YourGetTextVariable=YourGetTextVariable.Split(" "c)(0)

[Gokul001 (Gokul Balaji)]

You can also try with Split expression

Split("2,604,000.00 SGD","SGD")(0)

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Check out the image @alvin.c.apostol26

Split("2,604,000.00 SGD","SGD")(0).Replace(",","")

Regards
Gokul