Hi I have an issue where by I have lots of products in a field which are comma delimited I want to replace those product words with a id number that I have in a different table.
I currently use FIND INSET to replace a tab to the comma but currently cant see how I would you that type to change what I need to.
Here is my data
So I need to replace Table 1 product_field with Table 2.id so result would be
Can anyone help please