Wondering if anyone can help me out and review this REGEX_Match function I'm trying to write.
I have two patterns of data:
Here's the expression:
REGEX_Match([tamt],
"\d*\.\d+#+\d*\.\d+|
\d+#+\d+")
This is running through the following workflow:
But the false filter is spitting out the following results:
Where the subset of patterns within the red box are pushing to the false output on the filter. I thought with the '\d+#+\d+' pattern string would have forced these values into the true output.
Data's sensitive so I hesitate to share the data set but wondering if anyone has any ideas given the fact pattern above.
Thanks!
Solved! Go to Solution.
@JosephSerpis thanks this worked!
Do you know why the tool forces the order the way it does? If there's an article you could point me to, that'd also work (as I know the RegEx explanations can get lengthy).
Thanks again for the help!
Hi @mmvcans — You can try this solution too:
If this solves your issue please mark the answer "Solved" with a Like, if not let me know!