How do use RegEx Matches and Replace

[afinity_lim]

Hi All

Need your advice. I am trying to extract data from email.

Gross Salary (A) 8000

How do I use RegEx (Match and replace) to obtain 8000?

[ppr (Peter Preuss)]

@afinity_lim
Welcome to the forum

find starter help here:
Demo_Replace_Activity-Api.xaml (5.8 KB)

for a replace it is mandatory to specify the replace value, so I implemented with empty string for demo purpose.

Retrieving the value we would use the Match Activity or the Api as below

Ensure following:

And have a look here as well:

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…

[HimanshuSonawane]

hi @afinity_lim

Welcome to Community .You can use below regex to capture the amount .

REGEX :-

(?<=Gross Salary \WA\W )\d*(?=\s)

This regex will help to find Gross Salary (A) first and then after matching the test it will fetch next integers value i.e 8000 in above example after Gross Salary (A).

please find below xaml file for same .
Main.xaml (5.1 KB)

Hope this help your problem statement .

[Pratik_Wavhal]

Hi @afinity_lim

Just have a look to the below regex :-

Output :-

Group1 is your output

regex101: build, test, and debug regex

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[afinity_lim]

Hi All

Thanks for your advice and guidance…