Error on Extracting pdf data

Help
, , ,
1

Hi, i want to get “To:” data address from invoice pdf as i
given below (System.Text.RegularExpressions.Regex.Match(txt,“(?<=To:).+”).ToString.Trim) this line of code is working for getting data from next element but i want to get data from down of “To:” address, so can you edit this code and given me the code

Invoice1
Invoice11045×542 27.7 KB
@Palaniyappan @Shweta1717 @Sidney_Vogel

Note: i tried scrapping, but i want get data dynamically

2

@gokul_t Hi, scraping could also work dinamicly since the PDF file invoice is the same format for that invoice, so the location of “To” will never change, You can use Get OCR Text and store it in a variable and use it as you wish or format it the way you want, that is how i have done it. so its one way of doing it, just sharing my thoughts.

3

I am doing for multiple format of invoice, so address size is getting varied @Sidney_Vogel

4

Hi @gokul_t,

Are you got the solution? Its Scanned PDF or protected PDF? if you share the PDF & I will check from my side.

5

@Sidney_Vogel Hi, can you check the pdf invoice i have given below wordpress.pdf (42.6 KB)

6

Hey @gokul_t,
Step 1: Read PDF Text Activity, Please refer to the Screenshot.
image
Step 2 : Matches Activity → Input Parameter → 1.WordString(output from Read PDF Text activity) & Pattern as To:.\n..\n..\n..\n..\n.*. & Please refer the screenshot given below

WordPress_ToAddress
WordPress_ToAddress1366×768 162 KB

7

System.Text.RegularExpressions.Regex.Match(txt,“(?<=To:.\n..\n..\n..\n..\n.*.).+”).ToString.Trim this Expression not working can you suggest me any other @Vivek.A.S

8

Hi @gokul_t,

Use abby Ocr or CV to get the data & use this regex “(?sim)(?<=To:)(.*)”

9

HI @varunk I used this code System.Text.RegularExpressions.Regex.Match(txt,“(?sim)(?<=To:)(.*)”).ToString.Trim i am getting total text but i given “To:” has i attached my screenshot and attachment my project can please check it

Screenshot%20(68)
Screenshot%20(68)1366×768 156 KB
InvoiceDemo.zip (67.5 KB)

10

HI @varunk I used this code System.Text.RegularExpressions.Regex.Match(txt,“(?sim)(?<=To:)(.*)”).ToString.Trim i am getting total text but i given “To:” has i attached my screenshot and attachment my project can please check itSequence.xaml (8.9 KB)

11

Hey @gokul_t, Am Getting the output & Change the Pattern → Please refer the screenshot given below
image

12

Hi @Vivek.A.S Can you say how to print matching value, I have sent screenshot and project below Sequence.xaml (7.5 KB)

Screenshot%20(70)
Screenshot%20(70)1366×768 104 KB

13

Hey @gokul_t,Refer the screenshot

image
image960×293 12.5 KB

14

Hey @gokul_t,Refer the screenshot
image

15

Hi @Vivek.A.S matching result should be saved in string or any variable

16

Use Assign Activity , you Can assign to New_Variable as String
New_variable = WP_TO_ADD(0).value

17

Hi @Vivek.A.S i have created variable as string i am getting error as i given below

Screenshot%20(71)
Screenshot%20(71)1366×768 114 KB
Sequence.xaml (8.1 KB)

18

Check out this xaml File → Sequence.xaml (8.1 KB)

19

Hi @Vivek.A.S, Thank you its working fine, but if i try for same logic for “From:” its not working

Screenshot%20(72)_LI
Screenshot%20(72)_LI1366×768 170 KB

20

Please check out this xaml for From Address & To Address → Sequence.xaml (9.8 KB) and then mark it as Solution.