Is there a function within Assure that we could leverage during matching that would attempt to match a “left” item field to an inconsistent portion of a “right” item field.
For example, “left” item Field A = 123 and “right” item Field B = 123456789 OR 456123789 OR 456789123. Both items contain 123, but the right side may or may not be in the same place day to day.
We want to take the left item value and scan a larger right item value for the left value, and then match if it is found.
Thank you.