How to get specific text from a pdf

[BXP]

Hello all,
I am trying to get particular text(QuoteNumber) from a pdf from a folder called ‘Data’ in my current directory. I am using anchorGetDatafromPDF.xaml (6.8 KB) base to get my text but somehow i am not getting the desired output.Kindly help me out.

Below is the pdf image for reference.

Thanks in advance.

[AshwinS2 (Ashwin S)]

Hi @BXP

Use read pdf text with ocr activity and pass the value as string

Use is match and pass the input as strinput and pattern as (?<=QUOTE NUMBER:).* you ll be only that value

Thanjks
Ashwin S

[Vashisht (Vashisht Devasani)]

Hi @BXP,
Its tough to find using anchor base it may not be right.
1.Use the read PDF with OCR or Read PDF Text Activity from the pdf activities package in the manage packages.
2.Then you can extract the required text from the output string.
Cheers.
If you find it useful mark it as solution and close the thread.
Any queries ping me bro…
Vashisht.

[BXP]

Hello @AshwinS2,
Thanks for your suggestion, I am working on this so after the condition in Is Match satisfies i am getting the result as boolean but how do i get the Quote number next to it?

Regards,
BXP

[Vashisht (Vashisht Devasani)]

Hi @BXP,
you can use the split function

[Mohansadaiyapillai (Mohanraj S)]

@BXP,

I have created a workflow based on your requirement.
Please unzip the folder and check it out whether it is giving solution or not.

Thanks,
Mohanraj.SSplit.zip (268.1 KB)

[BXP]

hello @Vashisht @Mohansadaiyapillai,

My pdf document has two pages with multiple line, so its hard to use split function.

Thanks,
BXP

[Vashisht (Vashisht Devasani)]

Can you share the PDF?

[BXP]

Hey,

I dont have the access to share the pdf but i can send you the .txt file extracted from pdf.

Regards,
BXP

[pattyricarte (Patty Boy)]

Hi @BXP

Try to use Flexi Abby if you have multiple format of pdf?

cheers

Happy learning

[Vashisht (Vashisht Devasani)]

Yeah please share the txt file

[BXP]

Hello @Vashisht ,

The issue is resolved, i used Read PDF Text activity and converted to string and later used Regex to get that particular text from the pdf text.
In Assign activity

QuoteNo=System.Text.RegularExpressions.Regex.Match( PdfData,“(?<=QUOTE NUMBER:).*(?=DATE:)”).value

Then i got my quote number.

Regards,
BP