Fuzzy Match Smaller Delimited String within Larger Delimited String

[muddobber26]

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?

[ArtApa]

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

[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 · Accepted solution]

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: