Help Needed: Formatting PDF Text to Table Using RegEx

Question

Hi Community,

I've extracted several PDFs using the "PDF to Text" tool with the "Lines" method. The extracted result is attached.

I attempted to format the output into a table using RegEx to match the structure shown in the attached image. However, I'm not getting the expected results.

I've also attached the workflow I used for testing. I'd really appreciate it if anyone could help me resolve this issue.

Alteryx PDF to Text-Lines.xlsx

Test.yxmd

Screenshot 2025-07-10 111359.png

aatalai · Accepted Answer

@buddhiDB I brought the image in again and used a table extraction (that might help at a pdf level) and giving it a template. This might be a nice workaround, also attacehd a workflow, please let me know how you get on

aatalai · Accepted Answer

@buddhiDB use the pdf to text and set the template that way, You can also filter to only look at the second page of your input too. I've attached an example from Alteryx

hard to give a clearly example with out data