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?
Thank you,
Solved! Go to Solution.
@JonaV90 ,
I've used two tools due to the first Regex statement (hours) consuming the string.
This gives me:
Workflow attached.
M
Thank you!!!@BS_THE_ANALYST