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
14 - Magnetar

@JonaV90 you're very welcome. Happy RegExing 😀

 

Labels