looking to match a certain format

[lliberm1]

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

[echuong1]

You can use RegEx functions to identify patterns of values. See below for information: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689

These formulas can also work within the filter and formula tools. See attached for an example that looks for values that are 3 letters or 3 letters followed by -##/##. Let me know if that works!

[CharlieS · Accepted solution]

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.