We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need help with Regex to extract text from string

Pranab_C
8 - Asteroid

Hi Alteryx Champions,

 

Need help in extracting as depicted in Regex-1.png however the text is getting split as depicted in Regex-2.png.

 

I need the entire row "Tell us about the states, provinces, and territories you were in during the tax year" in one place and "Done" in the second one, however it is getting split into 3 

 

 

 

13 REPLIES 13
Pranab_C
8 - Asteroid

Thank you so much, that worked out well

Pranab_C
8 - Asteroid

Hi Andrew-thank you so much for sharing the updated workflow, it works perfectly fine, however the same PDF file has information that comes out in a table format (see attached). Can you please let me know how we can extract this information. 

CoG
14 - Magnetar

The method is pretty much identical to the workflow I shared with you. You just need to identify where the text is positioned and use that information to parse through and join together appropriate words that belong in a single cell. A larger table will require more work, but can be done in a very similar way. If this is all in the same PDF, then you will need to filter on something that is unique between pages that would allow you to determine which type of table you are working with and what data you need.

Pranab_C
8 - Asteroid

Hi Andrew, Could you guide on how to extract information from this table, this is part of the same PDF file. Attaching the page again

Labels
Top Solution Authors