I wanted to extract PDF table into excel with same format. Please find the attacheInterview Exercise_2.pdf (209.0 KB) d PDF file help me here.
you getting a digitally generated one or Scanned one ?
if it’s digitally generated one you can use Regex. Otherwise you need to use OCR extraction.
@Shaik.Yezdani uploaded pdf is a scanned image though it can not be done using PDF Integration activities. You have to perform OCR which is not recommended solution.
In this video, I extract tables from PDF and write data in Excel:
0:25 Install PDF Activities
1:10 READ PDF text, Get PDF page count, Extract PDF
5:40 Read PDF with OCR
6:55 Join PDF and Manage PDF passwords
9:30 Extract Images From PDF and Export PDF as Image
12:00 Extract table from PDF use-cases 1 replace some spaces with | (one column has multiple words)
24:00 Run the robot to see the result
25:40 Extract Table from other PDF use-cases 2 delimiter is 2*spaces " " easy split
31:50 Extract Table from complex PDF use-cases 3 unstructured data the logic will be based on IsUpper and IsLower
40:25 Extract the price value from PDF