Hi All,
I am trying to better myself at Regex and need to cleanse a data set [example image]. I basically need to parse the entire string after Home or Home -. what is the best way to write a regex for this pls?
Solved! Go to Solution.
Keep it simple:
If [Start Location] = "Home" THEN "" ELSE
Substring([Start Location],5)
ENDIF
Cheers,
Mark
Hi @ManuelRodrigues,
You can also use the regex tool in Alteryx to do this. You will want an expression like this:
HOME-(.*+)
The capturing group in the parenthesis will be anything after HOME. I use regex101.com to help me with regex.
If this helped your problem, please mark as a solution to help other members!
Thanks,