looking to match a certain format

Question

I have a workflow that is looking for certain criteria and if they match it filters through to another filter to check to see if my code matches another data set code.

For example, if first filter criteria is true, a 2nd filter shows does my code (which shows EUR for example) equal their code (which shows EUR) so we are good.  However my code may show EUR and their code may show EUR-##/## where # is any number.  I want these to match as true as well in this format only but not something such as EUR-SEK which may also occur.  What is the best way to isolate to either EUR or EUR-##/## where it will always be in this format.  I want to do this in the custom filter box where I have the basic equals equation and then add an OR to pull this scenario in (without manually putting EUR-01/01 all the way through EUR-99/99)

Thanks,

lee

CharlieS · Accepted Answer

I second what @echuong1 said about RegEx. There's a function RegEx_Match( that's perfect for this situation. Try the following expression in a Filter tool (in custom mode):

REGEX_Match([Code],"EUR-\d{2}/\d{2}")

The attached workflow shows this in action.

Edit: I see now that we've posted the same thing. gg.