I have two tables. the first table has 1 field records of strings that vary in overall length and each string has many spaces and many parenthesis. Each of these strings has multiple occurences of substrings, all different within the string. I have another table that has 2 field records of each substring, the substring along with its respective description. what I would like to do is replace all instances of the substring in the first table's records with the substrings description for the second table and insert into a results table.
Example:
1st table record value: Fred or Jane and (bob or Alice) and not (bill or joey).
2nd table records: Fred/Tall, Jane/Redhead, Bob/Bald, Alice/short, Bill/glasses, Joey/mustache
result being: tall or redhead and (bald or short) and not (glasses or mustache).
I am an amateur with vba so be nice