Extract tabular data from pdf file to excel shared file

@loginerror @nisargkadam23 @NIVED_NAMBIAR @Ishmeet_Bindra @ppr @JuveriaSiddiqui @HANACCHI @cheez_RPA @anoosha6 @mvpmurali

have pdf where data in form of rows and columns like

I need to take these things in excel .

Please guide

Get all the data as a string in a PDF related activity

The line with 6 consecutive numbers is like the first line, so substitute it for a new string

If there are no 6 consecutive numbers, concatenate to the previous string

Expand the blocks before and after 6 consecutive numbers and characters that can be recognized as a date in each column.

Since “SUBJ_LAST_NAME” and “SUBJ_MIDDLE” are likely to be the same block, we will expand them with business knowledge. may be.