RegEx Parse

Question

Wondering if anyone can help me out and review this REGEX_Match function I'm trying to write.

I have two patterns of data:

* 1#1
* .01#.01 OR 1.01#1.01

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!

JosephSerpis · Accepted Answer

Hi @mmvcans try this syntax

REGEX_Match([tamt],
"\d+\#+\d+|\d*\.\d+\#+\d*\.\d+")

JosephSerpis · Accepted Answer

Hi @mmvcans this article might be helpful and explain order in the way regex excutes.

vizAlter · Accepted Answer

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!