How to extract pdf table data in multiple pages

kalv · December 28, 2020, 10:54am

Hi All,

I have to extract table in pdf (image based). Table appears from second page till multiple pages. Table rows count is dynamic.

Cristian_Negulescu · February 28, 2021, 7:40pm

Hello Kalv,
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
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
How do we scrap a pdf that has a table which extends to the next page? Studio datatable , excel , selector , studio , data_scraping , question	2	1425	February 28, 2021
How to extract tables when multiple pages in pdf file Studio studio , question , activities_panel	9	771	November 23, 2023
Multipage PDF Data Extraction Studio	4	1506	February 28, 2021

How to extract pdf table data in multiple pages

Related topics