String exact contains(Used contain formula but not working)

[j395liu]

I'm trying to build a workflow that have three columns as input (Column A, Column B and a search value) and output the result as the value in 'Desired Output' column. Basically search the target for example "ABC" in a list of strings "ABC","ABC22","3sABC" and only return 1 match result "ABC". 

I used formula tool in Alteryx with function Contains but in my cases above, the result is the target is contained in both A value and B value. I can't use filter because I've a list of different Search Target value in my real dataset. 

Thank you for your help in advance. Any ideas for how to build this workflow would be helpful.

[MarqueeCrew · Accepted solution]

@j395liu ,

Here's a helpful hint:

REGEX_Match([A], ".*\b"+[c]+"\b.*",0)

This will match DEF with 123 DEF Street, but not 123 DEf Road or 123 cDEFg ct).  Using this within an expression that checks column C against A with B, you should get your result.

Cheers,

Mark

[j395liu]

This is exactly what I'm looking for. I appreciate your help.😀

[MarqueeCrew]

You're welcome!   Lots of folks should get help from your post in the future. 

cheers