Forum Discussion
Solved
Search for exact value from table
Hi guys, I am working on a way to add a label to a big list of keywords. In this case i want to extract all keywords that contain a brandname. I've got a big list of keywords and a table with ke...
You may try the following expression.
SEARCH ( " " & DimBrand[name] & " ", " " & FactKeywords[Keyword] & " ", 1, 0 )
Perhaps try FIND instead of SEARCH. FIND is case-sensitive whereas SEARCH is not.
This could be part of the solution. I've capatalized each word in the keywords. With the Find function it helps for most part. But I want to know if there a better solution? Is still end up with too many wrong results.