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

Topic		Replies	Views
How to extract pdf table data in multiple pages Help studio , question	1	1112	February 28, 2021
PDF Table extraction Studio	9	15631	July 15, 2023
Data Scraping from PDF with multiple pages and tables in excel Activities pdf , activities , question	2	2397	February 28, 2021
Extracting the multiple tables in the single PDF page Activities pdf , activities , question	1	1202	February 28, 2021
Extract table data from multiple pages of a pdf file into excel file Help	3	1710	December 1, 2018

Multipage PDF Data Extraction

Related topics