String exact contains(Used contain formula but not working)

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.

Workflow

Accepted answers

MarqueeCrew

@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

All comments

MarqueeCrew

@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.😀

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703