Fuzzy Match Smaller Delimited String within Larger Delimited String

Hello - I have a column with delimited combination of part numbers. I want to be able to eliminate rows if the combination of part numbers is entirely contained within a LARGER combination of part numbers. Example: If one row is "456,890,321" and there is another row in the same column with "456,890,321,322" then I want to filter out the first combination of numbers. Is the fuzzy match tool the best way to do that?

Fuzzy Match

Accepted answers

ArtApa

Hi @muddobber26 - OK. I re-designed my solution to meet this new requirement.

The input:

456,890,321
456,890,321,322
500,600
333,444,555,666
333,444,555
123,456,890
123,333,456,890

The output:

Numbers
456,890,321,322
500,600
333,444,555,666
123,333,456,890

Workflow:

MatchAA2.0.yxmd

All comments

ArtApa

Hi @muddobber26 - If the number of records is not too big then this is a possible solution for you:

MatchAA.yxmd

muddobber26

Thanks for the response. Would this only work if the numbers were "next" to each other in the string? I.e., does the Contain function work if I am trying to find if 123,456,890 is in another string which is 123,333,456,890 where the first string is split up in the second string?

ArtApa

Hi @muddobber26 - OK. I re-designed my solution to meet this new requirement.

The input:

456,890,321
456,890,321,322
500,600
333,444,555,666
333,444,555
123,456,890
123,333,456,890

The output:

Numbers
456,890,321,322
500,600
333,444,555,666
123,333,456,890

Workflow:

MatchAA2.0.yxmd

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167