Extract specific table within PDF Form with RegEx

[supermanPunch (Arpan)]

@Ronke

FYI: the values in table are dynamic, some fields may or may not contain data on a case by case basis.

Hi @Ronke ,

When the table data may or may not contain data (such as empty values in some cells), we might not be able to get it right with the regex /String manipulation. We could try with the Approach of Generate Datatable Activity, trying all it’s combinations. If not successful, we give a try on the methods of Interop Word c#. You could check the post below for the example workflow.

PDF TABLES EXTRACTION EVEN WHEN ROWS ARE DYNAMIC

Hi @bhanusai_sajja , I believe the Sample PDF shared is a sample data only and not of confidential data. If it is confidential, Do Let me know. However, I am excluding the PDF sample that was provide to me in private. Check the below workflow : PDF_To_Excel_Corrected.zip (4.0 KB) The Data that you have provided, seemed to have some problem with the column name, and hence it was throwing out error. I did correct that part by implementing a counter/index to the column names if it was already h…

However, even with this method, it would not work always for some of the PDF types. We would need to perform a thorough check with the types of PDF that you would receive and then confirm if this works for all cases.