I would like to link two tables using the Description field in both tables with records being matched by a common text. E.g. a record with description "aaaa Q2517 bbbb" from one table would be matched with description "ccc dd Q2517 eee f" from another table based on Q2517 text. How would I do that using NL function? Thank you
Date
Votes
2 comments
-
Harry Lewis Hello Vladimir -
You could use a technique similar to this:
I had to make a few changes to match my sample data. I'm looking for customers whose name contains the first word from the item description:
Mainly, it's a matter of applying the string manipulation you need.
-
Vladimir Safonenko Excellent. It helped. Thank you.
Please sign in to leave a comment.