I hope this isn’t a dumb question as I’m new around here. I’ve managed to get a long way through my first project but hit a block I can’t solve so I’m hoping somebody with more experience can advise.
I have 2 tables.
Table 1 is my primary table,
Table 2 is for lookup data.
I need to look in a column in Table 1 to see if any of the entries from a particular column in Table 2 are contained in the text string. If found, replace with a value from another column in Table 2, if not, do nothing.
So for example
Table 1 - string in “High tide time in Laguna Beach”
Table 2 - lookup column “High Tide”
Replace with “<>”
updated Table 1 string would read “<> time in Laguna Beach”
Can anyone advise a method to achieve this please? Thanks in advance.