Hi,
I want to read a particular cell value in the pdf i.e the value of the first row, first column if it is more than 0 i need to put a message box.
How do i do that?
Hi @RACHEL_PAUL ,
Try using Read PDF Text activity and get the Data in the form of text, You can then extract the required based on the other Constant Data available either by using String/Regex Manipulations.
To Help further, If you could let us know if the format of the PDF will remain the same always, then you could provide us with the Sample data and mark the data that needs to be extracted. So that we can provide you with the appropriate suggestion.
- i need to read the first 1st column of the 2 rows if the value is more than zero.
The format of the PDF is the same always.
SearchResult.pdf (119.5 KB)
HI,
How about the following?
m = System.Text.RegularExpressions.Regex.Match(strPdf,"A search of Heritage NSW AHIMS Web Services \(Aboriginal Heritage Information Management System\) has shown\s+that:\s+(?<FIRST>\d+).*\n(?<SECOND>\d+)")
Then
m.Groups("FIRST").Value
m.Groups("SECOND").Value
Sample20230516-5L.zip (115.8 KB)
Regards,
This works.
Thank you @Yoichi .
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.