Forum Discussion

tomgag's avatar
tomgag
Resolver I
8 years ago
Solved

Find text annd exclude certain strings

Hi, I want to find the string withing my column and exlude if certain strings are present. I use the following code:   Lookup= IF (ISBLANK ( SEARCH ( "Ronaldo", Table[Column], 1, BLANK () ) ), "",...
  • tomgag's avatar
    tomgag
    8 years ago

    Solution is:

     

    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-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi tomgag,

 

Could you please mark the proper answers as solutions?

 

 

Best Regards,

Dale

tomgag's avatar
tomgag
Resolver I
8 years ago

Solution is:

 

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)