Extract currency value using regular expressions

[deepaksvg99 (deepak)]

Need to extract currency value ex. have value SAR 0.00,SAR 1,456,254.00 like this and I want only values 0.00,1.456,524.00
Have tried with split functionality but getting error as " index out of box" initially the split is working as expected but after some time it is showing this message.
I am assigning the value as
stClosing_Bal= SAR 0.00 or stClosing_Bal= SAR 1,456,254.02
Output: stClosing_Bal= 0.00 or 1,456,254.02

[Steven_McKeering]

Hello

I think I understand your sample…

Regex Pattern:

(?<=SAR\s)[\d,.]+

Take a look at this solution

regex101: build, test, and debug regex

Want to learn Regex? Check out my Mega post

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

[athira.somasekharan]

Hi,
Can you try using this in Assign:
stClosing_Bal.Replace(“SAR”,“”).trim
Thanks.

[deepaksvg99 (deepak)]

Hi [Steven_McKeering],
Thanks for the reply.
Sorry that I forgot to say that SAR is not constant. The currency symbol can change
Ex: INR 0.00, USD 1,254,458.23

[Steven_McKeering]

Hey @deepaksvg99

Okay, let’s try this pattern:

(?<=[A-Z]{3}\s)[\d,.]+

[nikhil.girish]

@deepaksvg99 try out this
System.Text.RegularExpressions.Regex.Replace(Test, “[^0-9]”, “”)

Where Test in that expression will be ur variable name

[deepaksvg99 (deepak)]

Hi Steven,
Thank you very much for your support and the code

[deepaksvg99 (deepak)]

Hi Nikhil,
Thank you for the code. It is working

[nikhil.girish]

Please mark it as solution
happy learning