How to extract table from pdf file without using document understanding and regex to an excel sheet

Help Studio
1

Hi Team,

here is the sample file, i need to extract only the table which is marked in yellow to an excel sheet, how do i do this without using document understanding and regex…i had tried using pdf activy and generate data table but it is copyinf the entire data to excel with no proper format so please help me to achive this

image
image1332×667 72.5 KB

2

@bhanupriya.cb

  1. Use ‘Read PDF Text’ activity to extract text from the PDF.
  2. Identify the start and end points of the table in the extracted text.
  3. Use string manipulation or splitting to extract the table data.
  4. Format the extracted data into a DataTable.
  5. Use ‘Write Range’ activity to write the DataTable to an Excel sheet.
3

Hi @bhanupriya.cb

Please check on this

Regards,

4

@bhanupriya.cb

check above thread