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.
Solved! Go to Solution.
I intend to use this for replace or match purposes.
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
Thank you so much @OllieClarke this is really helpful.