If data within the PDF files is tabulated we need to extract the data by rows and then use the text to columns function in Excel in order to replicate the table structure.
To extract rows we need to specify the start and end text. End text is simple as it will be a new line by using the [new line] option. The start text is more complicated as the extraction will return whatever is found after the starting text. We can specify the first column text and replace it afterward is there is a common pattern. Alternatively if a common pattern exists the the last column of the prevoius row or text then we can use that with [new line] to extract the entire subsequent row.
