How to Extract the fields from pdf using Regex

[adarsh_kotagiri]

Hi Team,

Here i am trying to Extract the Fields by using the Regular expression, can any one help me out how to do this for the given sample input as shown below.

Here input i am using is Native pdf, as shown below.

After Convrting in to Text i am getting this text file, as shown below.
Output_Text.txt (486 Bytes)

So the Required output in excel, as shown below.
Output Excel.xlsx (9.1 KB)

Here i am not considering the Description Column
Thanks in advance.

[Sudharsan_Ka]

HI @adarsh_kotagiri

Checkout this threads

PDF Table extraction

Hi @anand.t, You can try this approach in this thread: Convert PDF Datatable to Excel - Build - UiPath Community Forum If your table has multiple headers, this first approach may not work because the way the table is obtained read and values seperated using string manipulation. If it is a standard single header type, then this will work just fine with some .replace(SEPARATORS,","). Possible solution for multiple headers (may need string manipulation): Brainstorming Solutions for Editing …

PDF Table extraction

Hello Anand, In this video, I have 17 use-cases for extracting tables from PDF and write data in Excel and I have also exampels with multiple pages: [UiPath extract Tables from PDF (use case) (PDF table)] 45:50 File 10 PDF with multiple columns that have multiple lines + multiple pages 1:17:10 File 19 PDF with multiple pages and columns with multiple lines Code: Thanks, Cristian Negulescu

How to extract table data from pdf

@lakshmi.mp Go to manage packages> All package > download package FestSystems.PDFtoExcel.Activities [image] Split the pdf into single single pages using a pdf splitter activity and use the pdf to excel activity [image] Regard Muhamed fasil

Regards
Sudharsan

[Yoichi]

HI,

Can you try the following sample?

mc = System.Text.RegularExpressions.Regex.Matches(strData,"^(?<INVREF>\S+)\s+(?<POSTDATE>\d{2}/\d{2}/\d{4}).*?(?<INVDATE>\d{2}/\d{2}/\d{4})\s+(?<GROSSAMOUNT>[-\d.,]+)\s+(?<TDS>[-\d.,]+)\s+(?<AMOUNT>[-\d.,]+)",System.Text.RegularExpressions.RegexOptions.Multiline)

Then, set the following at ArrayRow

{m.Groups("INVREF").Value,DateTime.ParseExact(m.Groups("POSTDATE").Value,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture),DateTime.ParseExact(m.Groups("INVDATE").Value,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture),m.Groups("GROSSAMOUNT").Value,m.Groups("TDS").Value,m.Groups("AMOUNT").Value}

Sample20230120-3L.zip (4.1 KB)

Regards,

[csmart (Chirag Morakhia)]

Go through this video.

RegEx

[adarsh_kotagiri]

Hi @Yoichi

Thank you so much for the work flow, it is working fine, the only challange i am facing is i am unable get the multi line data in single row as shown below.

The output i am getting in this format.

But my Excepted Out put is

Please help me in this.

Thanks in advance.

[Yoichi]

HI,

It seems difficult to identify which string should be added to INV.REF string in the previous line.

If string to be added always consists of numeric characters at the beginning of the line, the following will work.
(However, i suppose it may not work as there are various cases…)

Sample20230120-3Lv2.zip (4.6 KB)

Regards,

[supermanPunch (Arpan)]

Hi @adarsh_kotagiri ,

Could you maybe try checking the below post on PDF Table Extraction. Here the input is the native PDF text file itself.

Converting Pdf table to excel

@Amit_Kumar_Charde , In that case, we should be able to read the PDF data using PDF Activities and apply String/Regex manipulation to get the data into a Datatable format. Is it possible for you to provide us with the PDF document or a Sample of that PDF having the same pattern of data as the original PDF document ? We could check if a String/Regex manipulation would be an easier approach for the pattern of PDF data that you receive. Additionally, Could you Check with the below workflow : P…

Let us know if this does not help for your case.

[adarsh_kotagiri]

Thank you @Yoichi its working perfectly and i learned something new.