Multipage PDF Data Extraction

anand.t · January 21, 2021, 10:13am

Hi ALL

I am facing one issue while extracting data from PDF some rows are split that is why my data output is shrinking. Pease find the example

Please see the value of fifth column here table row is split.

The output data value.

2026.8 0 should be in quantity column and accordingly.

If any body is any guideline please tell me. We have more that 500 PDFs with different pattern but Table columns are same.

Note: PDF Data table value is varying it could be 5 pages or 10 pages not fixed. For example bank transaction statement.

Strategy: I am converting that PDFs in word document format and searching table here. And using Data scraping I am getting the data is structured tabular format.

Regards
AN

sangeethaneelavannan1 · January 22, 2021, 4:21am

If I could get some pdf files, I can try this scenario. Do you have any sample file(not company files)?.

Thanks,
Sangeetha.

anand.t · January 22, 2021, 4:29am

@sangeethaneelavannan1

Thanks for support but this is company sensitive data so unable to share the PDFs.

Here line is break so it is considering one row .

Regards
AN

sangeethaneelavannan1 · January 22, 2021, 4:31am

I completely understand that.

Cristian_Negulescu · February 28, 2021, 7:52pm

Hello Anand,
In this video, I have 17 use-cases for extracting tables from PDF and write data in Excel and I have also samples with multiple pages:

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:

github.com

cristinegulescu/startUiPathFromSalesforce/blob/master/PDFdecode.txt

        'FILE1
        Dim strtmp As String
        strtmp = strin.Substring(strin.IndexOf("Number"), strin.IndexOf("Subtotal") - strin.IndexOf("Number")).Trim
        strout = strtmp.Replace(" ", "|")

        strtmp = strin.Substring(strin.IndexOf("Subtotal") + 8)
        strpar = strtmp.Substring(0, strtmp.IndexOf(Environment.NewLine)).Trim


        'FILE2
        Dim strtmp As String
        Dim strout As String
        strout = "Col1|Col2|Col3|Col4"
        strtmp = strin.Substring(strin.IndexOf("Vacancies") + 11).Trim
        For Each line As String In strtmp.Split(New String() {Environment.NewLine}, StringSplitOptions.RemoveEmptyEntries)
            If (line.Length > 3) Then
                If (IsNumeric(line(0))) And (line(1) = " ") And (line(2) = " ") Then
                    strout = strout + Environment.NewLine + line.Replace("  ", "").Replace("  ", "|").Trim
                ElseIf (line(0) = "") And (line(1) = " ") And (line(2) = " ") Then
                    strout = strout + line.Replace("  ", "$").Trim()

This file has been truncated. show original

Thanks,
Cristian Negulescu

Most Active Users - Yesterday
ppr
Soudios
Vishnu_Reddy1
kumar.varun2
hurmet.noka
Ayman_Alabsi1
nikhil.girish
Veera_Raj
Dhanush_Naik
kaiji_San
More details...