Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

RegEx Match Problem

8 - Asteroid

Hi everyone,

I'm trying to see if my Values Match to a specific Pattern Although it works with (Parse Method) but it doesn't work with Match (Using RegEx tool)


the Values are:  


EB-Wert Soll
EB-Wert Haben
Summe für Januar Soll
Summe für Januar Haben
Januar - Januar Soll
Januar - Januar Haben


and i want to get 2 last Values with this RegEx 






but it gives me False for all Columns 

How can i achieve this?

And is there something to consider while working with RegEx Match ?

Alteryx Certified Partner
Alteryx Certified Partner

Hi @MostafaBouzari,


The difference with Regex Match method is the expression must match the entire string, otherwise it will return false.


You could use:




this would search for strings starting with Januar followed by a space, followed by a hypen, followed by a space, followed by a word, followed by a space, followed by a word.




If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow  for you to download if needed.