Forum Discussion

JeroniJamboni's avatar
JeroniJamboni
Icon for Advocate I rankAdvocate I
8 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    JeroniJamboni,

     

    You may try the following expression.

    SEARCH ( " " & DimBrand[name] & " ", " " & FactKeywords[Keyword] & " ", 1, 0 )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Perhaps try FIND instead of SEARCH. FIND is case-sensitive whereas SEARCH is not.

JeroniJamboni's avatar
JeroniJamboni
Icon for Advocate I rankAdvocate I
8 years ago

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.