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
SOLVED

RegEx Match Problem

Highlighted
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 

 

 

(Januar)\s-\s

 

 

but it gives me False for all Columns 

How can i achieve this?

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

Highlighted
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:

 

Januar\s-\s\<\w+\>\s\<\w+\>

 

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.

 

image.png

 

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.

 

Regards,

Jonathan

Labels