Forum Discussion

tomgag's avatar
tomgag
Icon for Resolver I rankResolver I
8 years ago
Solved

Search amd exclude certain strings

Hi, I have the search function but want to exclude certain strings.   Ball= IF (ISBLANK ( SEARCH ( "Messi", Table[Column], 1, BLANK () ) ), 0, 1 )   It gives me 1 or 0 depending if Messi is in...
Need Help
Show and Tell
  • tomgag's avatar
    tomgag
    8 years ago
    Ball = IF (NOT(ISBLANK ( SEARCH ( "Messi", 'Table'[Column], 1, BLANK () ) )) && ISBLANK ( SEARCH ( "Ronaldo", 'Table'[Column], 1, BLANK () ) ) && ISBLANK ( SEARCH ( "Pogba", 'Table'[Column], 1, BLANK () ) ), 1, 0)
tomgag's avatar
tomgag
Icon for Resolver I rankResolver I
8 years ago
Ball = IF (NOT(ISBLANK ( SEARCH ( "Messi", 'Table'[Column], 1, BLANK () ) )) && ISBLANK ( SEARCH ( "Ronaldo", 'Table'[Column], 1, BLANK () ) ) && ISBLANK ( SEARCH ( "Pogba", 'Table'[Column], 1, BLANK () ) ), 1, 0)
  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    8 years ago

    My code will work but if you got it resolved, tha'ts what all matters. There is always many way to do the things. Good for you!!

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi tomgag,

     

    It's glad that you have solved your problem. Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    Best Regargds,

    Cherry

    • tomgag's avatar
      tomgag
      Icon for Resolver I rankResolver I
      8 years ago

      None of your solutions worked I am afraid.