How to uniquely identify field using regex pattern?

[Vaishnav_Tej]

Hi all,

I’m trying to extract the value of field “Total” using Regex Pattern of “Matches” Activity.

Fields available :
Total $93.50
Sub Total $85.00

Pattern I gave :
(?<=Total)(.*)
Output I’m getting:

But I want to fetch only TOTAL value.

Any help would be appreciated:-)

[Anil_G]

@Vaishnav_Tej

Total $93.50
Sub Total $85.00

@Vaishnav_Tej

Please try this

(?<=^Total.*)\d+.\d+

cheers

[Yoichi]

Hi,

Can you try the following pattern?

(?<=(?<!Sub\s*)Total\s*)\$\d+

OR

(?<=(?<!Sub\s*)Total\s*\$)\d+

Regards,

[Vaishnav_Tej]

This expression is not extracting any of the values.
It just started execution and ended.

[Vaishnav_Tej]

@Yoichi

(?<=(?<!Sub\s*)Total\s*\$)\d+

Hello sir,

This expression is not fetching decimal values.

[Yoichi]

Hi,

Sorry, how about the following?

(?<=(?<!Sub\s*)Total\s*)\$[.,\d]+

OR

(?<=(?<!Sub\s*)Total\s*\$)[.,\d]+

Regards,

[Vaishnav_Tej]

@Yoichi

(?<=(?<!Sub\s*)Total\s*)\$[.,\d]+

Thank you sir. It’s working perfectly.
Could you please share any link where I can learn regex.

[Anil_G]

@Vaishnav_Tej

Please include like this

System.Text.RegularExpressions.Regex.Matches(str,"(?<=^Total.*)\d+\.\d+",RegexOptions.Multiline)(0)

cheers

[Vaishnav_Tej]

Actually I’m using Matches activity and inside pattern property I’m passing the expression.
Thanks for your response:-)

[Anil_G]

@Vaishnav_Tej

Even there you have this option

cheers

[Vaishnav_Tej]

oh Could you please share any link where I can learn about Regex ?

[Anil_G]

@Vaishnav_Tej

regex101: build, test, and debug regex

Regex Tutorial—From Regex 101 to Advanced Regex

cheers

[Yoichi]

@Vaishnav_Tej

Could you please share any link where I can learn regex.

For now, the following might help you as first step.( However, this might be easy for you because you already know look behind.)

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…

Regards,