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)
parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago
Ball= 
IF (
ISBLANK ( SEARCH ( "Messi", Table[Column], 1, BLANK () ) )
&&
(
ISBLANK ( SEARCH ( "Ronaldo", Table[Column], 1, BLANK () ) )
||
ISBLANK ( SEARCH ( "Pogba", Table[Column], 1, BLANK () ) )

)
,
0,
1
)
tomgag's avatar
tomgag
Icon for Resolver I rankResolver I
8 years ago

I give 1 when Messi and Ronaldo or Pogba inside the string.