Write Regular Expression

[Gamaliel]

Hello,

I am still new to  alteryx, can you teach me how to write regular expression for this?

This is what I entered but it wont work: \d{5}\W[[:alpha:]]+\s\W+\w+\W[[:alpha:]]+

Thank you.

[mceleavey]

Hi @Gamaliel ,

What are you trying to do? Can you please provide your expected results?

Thanks,

M.

[Gamaliel]

I intend to use this for replace or match purposes. 

[OllieClarke · Accepted solution]

Hey @Gamaliel 

The issue with your RegEx is that [[:alpha:]] doesn't include spaces, so "Handsome Gamaliel" isn't being matched (for example).

If you change the [[:alpha:]]s for [a-zA-Z ] (a set of all letters and also spaces), then your RegEx should work:

\d{5}\W[a-zA-Z ]+\W+[a-zA-Z ]+\W[a-zA-Z ]+

Hope that helps,

Ollie

[Gamaliel]

Thank you so much @OllieClarke  this is really helpful.