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

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

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

Can you confirm your logic, it is not super clear

 

give example of your data and expected result.

 

 

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

    ;;;;

     

    Results should be:

    Ball

    0

    0

    0

    0

    1

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      8 years ago

      seems like you want if it is messi or ronaldo or pogba then 0 else 1 whereas you explain messi and ronaldo or pogba, is this correct understanding?

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

        'Messi is great' the result is 1

        'Messi and Ronaldo are great' the result is   0

        'Messi and Ronaldo or Pogba are great' the result is 0