Extract numbers from a string if they match a given list

Question

Hello,

Is there a way to pull values from a string if they match a list? I’m using regex_replace in the formula tool to extract these values, but the string isn't consistent (ie, preceding and proceeding text/characters may be different, per below example) and sometimes there's spacing/character issues so it doesn't always give me an output. so was wondering if I'd have a better chance if I provided the exact values, and have the workflow go through the whole list to find a match and extract it from the string. hope this makes sense. thank you in advance!

I'm on Alteryx Designer version 2024.1.1.93 if that helps.

sample list:

583920174
917463205
264851739

Sample Strings:

"ORIG: ACCOUNT NAME, INC. ID: 264851739BNF: RECIPIENT NAME LLC 123 SESAME ST ELMO PARK, NEW YORK 12345 US ID:583920174BNF BK: COOKIE MONSTER BANK"

"B/O BANK=/00917463205123 SESAME ST ELMO PARK, NEW YORK 12345 USCUSTOMER=/583920174 RECIPIENT NAME LLC 123 SESAME ST ELMO PARK, NEW YORK 12345 US BANK=/COOKIE MONSTER BANK"

Qiu · Answer

@bluelizard 
How about we first use Tokenize feature in RegEx tool to get all the Strings composited by Number then match with your sample list as below.

0930-bluelizard.yxmd

danettedavis · Answer

If you have a list of specific values that you are looking for you could use the find/replace tool to match off the string (your numbers would need to be converted to strings) but this should work to pull them out.

jrlindem · Answer

@bluelizard

Okay, so I experimented around a bit.  If you absolutely had to brute-force this and you could account for a reasonable small amount of variables...  Then you could do something like the attached.

Here's the workflow:

Here's the formula's.  They are broken out for illustrative purposes:

Once you have the values pulled from the strings, it's a simple JOIN to find the matches.

Not sure if this will totally cover your derivatives, but I think this might get you started!  Hope this helps,  -Jay

jrlindem_solution_option.yxmd