Forum Discussion

tomgag's avatar
tomgag
Resolver 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
Resolver 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)
v-piga-msft's avatar
v-piga-msft
Resident 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
    Resolver I
    8 years ago

    None of your solutions worked I am afraid.