Regex Help

[ManuelRodrigues]

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? 

[MarqueeCrew · Accepted solution]

@ManuelRodrigues ,

Keep it simple:

If [Start Location] = "Home" THEN "" ELSE

Substring([Start Location],5)

ENDIF

Cheers,

Mark

[CarliE]

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,

[messi007]

@ManuelRodrigues,

Another way to it :

Regards,