RegEx Match Problem

[MostafaBouzari]

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 ?

[Jonathan-Sherman · Accepted solution]

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.

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