Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Pulling out key pieces of data from a string pattern

JonaV90
7 - Meteor

Hi I am in the process of learning the RegEx tool and all other parsing tools.

 

I am trying to pull the hours from the below screenshot, so everything after "- block of" and before the dash (in some instances). So, essentially I want to pull a column that gives me the hours (in the first row it would be 10) and minutes (in the first row it would be 15). There are some instances where there are no minutes, only hours.

 

Can anyone help me do this?

 

JonaV90_0-1676493796568.png

 

Thank you,

 

12 REPLIES 12
mceleavey
17 - Castor
17 - Castor

@JonaV90 ,

I've used two tools due to the first Regex statement (hours) consuming the string.

 

This gives me:

 

mceleavey_0-1676495334229.png

 

 

Workflow attached.

 

M



Bulien

JonaV90
7 - Meteor

Thank you!!!@BS_THE_ANALYST 

BS_THE_ANALYST
15 - Aurora
15 - Aurora

@JonaV90 you're very welcome. Happy RegExing 😀

 

All the best,
BS

LinkedIN

Bulien
Labels
Top Solution Authors