How to extract particular values from pdf file data

Help Studio
, ,
1

Hi,

Actually I read the pdf file then I have overall string value like this,

Module : UW
Total Activity In Run : 8028
Total Error : 0
Correct Activity Debits : 8028 Total Error Debits : 0
Base Amts : 116,209,130.35 Base Amts : 0.00
Correct Activity Credits : 8028 Total Error Credits : 0
Base Amts : 116,209,130.35 Base Amts : 0.00
Extraction Start Date : 05/09/2024 Extraction End Date : 05/09/2024
Extraction Start Time : 15:53:12 Extraction End Time : 15:54:40
Posting Start Time : 16:36:06 Posting End Time : 16:36:06
Posting Start Date : 11/09/2024 Posting End Date : 11/09/2024

I want to extract two values from the above details, Please find the attached snapshot,

Please help me using regex expression or any other methods to extract the values.

A system activity report for module UW shows details on activity counts, debits, credits, and base amounts with the extraction and posting times and dates. (Captioned by AI)
A system activity report for module UW shows details on activity counts, debits, credits, and base amounts with the extraction and posting times and dates. (Captioned by AI)934×275 12.8 KB

Thanks in advance.

Regards,
Mukesh K A

2

Hi @mukeshsmart78

Try this

Value1 = System.Text.RegularExpressions.Regex.Matches(Input,"((?<=Base Amts :)([ \d,.]+)(?=.*\s*Correct))").First.ToString.Trim
Value2 = System.Text.RegularExpressions.Regex.Matches(Input,"((?<=Base Amts :)([ \d,.]+)(?=.*\s*Correct))").Last.ToString.Trim

The image shows a sequence of operations within a process flow, featuring assignments and write line activities, where values are extracted from a string using regular expressions in UiPath. (Captioned by AI)
The image shows a sequence of operations within a process flow, featuring assignments and write line activities, where values are extracted from a string using regular expressions in UiPath. (Captioned by AI)562×687 24.5 KB

Output:

The image shows an output log from a software process, with 'Value1' set to 116,209,130.35 and 'Value2' set to 0.00. (Captioned by AI)

Regards,

3

Hie @mukeshsmart78 for this simply you can use read pdf activity and save their output and use 1 assign activity of string variable and in the value field you can pass the variable of pdf for example
The image shows an assignment operation in a workflow that saves a value to the variable "strValue" by splitting a string "outputPdf" at "Refrence Field" and trimming the resulting string. (Captioned by AI)
try with this Example hope it work
cheers Happy Automation.