I need capture to address from reading a pdf

Help StudioX
,
1

Hello friends,
I need to capture specific to address part (highlighted part (bold)), sample text as below:
BASIC REPORT
ABCDE CIRCLE OFFICE BUILDING
116 W Market Street
Aberdeen, Washington 98520
PREPARED FOR:
Always Happy
BANK OF THE ASIA
4144 Hannegan Road
Bellingham, Washington 98226
PREPARED BY:
Rama Rao. Cathy, MAO, AO-GPRS
CASSINELLI VALUATION LLC
4804 NW Bethany Boulevard, Suite I-2 Portland, Oregon 97229
(503) 575-9217 / testx@cmail.com

Please help me in building the logic for the address part:

  1. Address will start with numeric (street number) and ends with five digit zip code.

Thanks

2

Hi @cschevuri

How about this expression?

System.Text.RegularExpression.Regex.Match(InputString,"(?s)^\d+(.*?)\d{5}").ToString.Trim

image
image1117Ă—408 61.8 KB

Regards
Gokul

3

Another Regex Patter @cschevuri

System.Text.RegularExpression.Regex.Match(InputString,"(?s)^\d+.*?\d{5}").ToString.Trim

image
image1108Ă—402 59.6 KB

Regards
Gokul

4

Thank you , will explore this.

5

Let us know if you have face any challenges @cschevuri

6

Main.xaml (7.0 KB)
project.json (1.6 KB)
Hi Gokul, please verify the above code, iam getting an error message.
Thanks

7

Hi @cschevuri

Try with this XAML file

Main (8).xaml (6.5 KB)

image

Regards
Gokul

8

Hey!

Try this…

  1. Read the pdf - Output as - strPDFOut
  2. Take one assign activity and create one string variable named strAddress

Pass the expression like this

LHS: strAddress

RHS: System.Text.RegularExpressions.Regex.Match(strPDFOut,"\d.*\n.*\d{5}$").ToString

Reference:

https://regex101.com/r/rJxTZn/1

Regards,
NaNi

9

Hi Gokul, Sorry.
i am getting the output same as it is captured from Input pdf sheet, as below:
BASIC REPORT
ABCDE CIRCLE OFFICE BUILDING
116 W Market Street
Aberdeen, Washington 98520
PREPARED FOR:
Always Happy
BANK OF THE ASIA
4144 Hannegan Road
Bellingham, Washington 98226
PREPARED BY:
Rama Rao. Cathy, MAO, AO-GPRS
CASSINELLI VALUATION LLC
4804 NW Bethany Boulevard, Suite I-2 Portland, Oregon 97229
(503) 575-9217 / testx@cmail.com

Expected output is
116 W Market Street
Aberdeen, Washington 98520

4144 Hannegan Road
Bellingham, Washington 98226

4804 NW Bethany Boulevard, Suite I-2 Portland, Oregon 97229

10

Hi Nani,
I tried your code, but it is returning the same input values captured from pdf.
Thanks
Chandra

11

Hey!

Try this…

System.Text.RegularExpressions.Regex.Match(StrInput,"\d.*\n.*\d{5}$|\d.*\d{5}$").ToString

Reference:

RegExNew
RegExNew897Ă—805 73.3 KB

Regards,
NaNi

12

HI @cschevuri

Can you share pdf file here

Regards
Gokul

13

Hi @cschevuri

image
image1115Ă—415 61.6 KB

Regards
Gokul

15

Hi Gokul, please find pdf as attached.
PDFsearch.pdf (40.3 KB)

16

Hi Nani,
I tried the above code, iam getting output as below:
image
Thanks.
Chandra

17

Hi @cschevuri

How about this expression?

System.Text.RegularExpressions.Regex.Match(InputString,"(?s)\s+\d+.*?\d{5}").ToString.Trim

Regards
Gokul

2 Likes
18

Hey!

Have you used writeline or Log message to display the output?

Try with Message box

Regards,
NaNi

20

Hi Gokul, This worked well, Thanks a lot.
Regards,
Chandra

21

Great @cschevuri

Happy Automation

22

Hi Nani
I tried write line command, but returning empty values.
The below code worked well:
System.Text.RegularExpressions.Regex.Match(PDFtext,“(?s)\s+\d+.*?\d{5}”).ToString.Trim

Thanks for your help.