0

I have the following table :

enter image description here

and on the other side I have a string that can contain words from the above table , ex: "Jeff El ABC THE DEF"

I need to do the following :

REPLACE("Jeff El ABC THE DEF", Select words from table,"");

So I need to remove any word found in the query result , any suggestions ?

Example:

input: "Jeff EL ABC THE DEF" query result : words[EL, THE, AL] expected output: "Jeff ABC DEF"

0 Answers0