Match One Value between Two Strings

[Bonediggler]

Experts - 

Here's the case: I need to figure out if there is at least one common value present in 2 different strings.  For example:

String A: 123, abd, edf

String B: 345,edf,789

In this case there is a match on "edf". 

I am looking for a solution that:

> Doesn't involve parsing and then transposing the strings as that will create millions of records

> Leaves the strings as they are

> Doesn't involve lots of tools - as I already have a solution that involves lots of tools

If I am overlooking an existing function or simple process to get this done, please let me know!

Thanks in advance!

[atcodedog05]

Hi @Bonediggler 

I have condensed the workflow for you. Who knew we would reach to a great solution 😅 But this definitely something to remember 🙂

Workflow:

Hope this helps : )