How to get Specific value using Matches activity?

[Vaishnav_Tej]

Hi All,

I want to extract total value from invoice pdf using matches activity. I’m able to extract only mail id’s and phone numbers. Rest all it’s a confusion for me.
Could someone please guide me how to configure regular expression. Also share any link where I can learn about RegEx.

Thanks in Advance

[Gokul_Jayakumar (Gokul Jai)]

Hello @Vaishnav_Tej
Based on your input, we need to frame the regex condition.
The document also should be in the desired format.
For Regex need, share your input and expected output, it help us to provide you a better solution

Kindly refer to this link, it may help you

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…

[AkshaySandhu (AkshaySingh Sandhu)]

Hello @Vaishnav_Tej
share some sample pdf data with us so that we help you better

For learning check TutotialsPoint and/or W3School etc

[Vaishnav_Tej]

wordpress.pdf (42.6 KB)

[Gokul_Jayakumar (Gokul Jai)]

@Vaishnav_Tej
Share your Expected output

[Vaishnav_Tej]

I want to extract values of Invoice Number, Invoice Date and Total Due.

Invoice Number INV-3337
Invoice Date January 25, 2016
Total $93.50

[Gokul_Jayakumar (Gokul Jai)]

@Vaishnav_Tej
Refer to this Xaml file, you may get some idea
Forum_PDF_Regex.zip (176.3 KB)

[Gokul_Jayakumar (Gokul Jai)]

@Vaishnav_Tej

Invoice Number INV-3337

System.Text.RegularExpressions.Regex.Match(ReadStr,"(?<=Invoice Number\s)[\dA-Za-z-]+").ToString

@Vaishnav_Tej

Invoice Date January 25, 2016

System.Text.RegularExpressions.Regex.Match(ReadStr,"(?<=Invoice\sDate\s)[A-Za-z]+\s\d{2}\W\s\d{4}").ToString

@Vaishnav_Tej

Total $93.50

System.Text.RegularExpressions.Regex.Match(ReadStr,"(?<=Total\sDue\s)[$\d.]+").ToString

[Vaishnav_Tej]

I couldn’t access

[Vaishnav_Tej]

What exactly to give in Pattern property?

[Gokul_Jayakumar (Gokul Jai)]

Dowload the packages from manage packages
UiPath.pdf.activities

[Gokul_Jayakumar (Gokul Jai)]

@Vaishnav_Tej
Use assign activity

Var= System.Text.RegularExpressions.Regex.Match(ReadStr,"(?<=Invoice Number\s)[\dA-Za-z-]+").ToString
Var should be string type