FIND REPLACE FUNCTION FOR NUMBERS

aamerin

I have two sets of data.

• Table one is a database of verified bar code numbers
• Table two is a list of bar codes that a client has sent (however, the numbers may be incorrect or incomplete)

What I would like to do is is write a version of find/replace function that says, if you find any part of "this bar code" from table two in table one, append the found bar code from table one.

I've tried the find/replace tool, but it seems to work mostly on text. I need something that can do this for numbers (or maybe I just need to understand the find/replace better).

Can someone help me out?

ponraj

Here is the sample workflow.  Hope this is helpful. You just need to convert numbers into string while comparing them. 

FIND REPLACE FUNCTION FOR NUMBERS.yxmd