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 ?
Solved! Go to 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