PARSING THE DATA THROUGH REGEX OR TEXT TO COLUMN

[Hammad_Rashid]

Hi All,

I am trying to convert a PDF into excel. For this, I used PDF input tool. Attached is the excel after conversion.

I am unable to parse the data from the 1st column. Please help me with parsing with REGEX or TEXT TO COLUMN, whatever applicable.

Thanks!

Could you please share the Workflow and explain how it works?

[danilang]

Hi @Hammad_Rashid 

This is complex problem with lots of possible answers.  Can you post the pdf, or at least an image of it so we can get a sense of how all the columns line up

Thanks

Dan

[Hammad_Rashid]

Thanks!