Skip to main content
Dear All,

 

I am looking for a solution regarding Blacklist words. I would like to blacklist some words but not words containings this bad words.

 

For example I would like to black list the word "homo" but accet the word "homonym"

 

Today I wrote this formula:

 

CONTAINS(UPPER(Description ),"HOMO"),

 

when I test it,  the word "Homonym" is also refused...

 

can you please help me?

 

 
6 respuestas
  1. 1 jun 2020, 15:41

    I suppose, if you don't want the description to end with the word you could use: 

    OR(

    CONTAINS(UPPER(Description )," HOMO "),

    AND(

    CONTAINS(UPPER(Description )," HOMO"),

    RIGHT(UPPER(Description),LEN(" HOMO"))=" HOMO"

    ),

    AND(

    CONTAINS(UPPER(Description ),"HOMO"),

    LEN(Description)=LEN("HOMO")

    )

    )

     

    That should get you there!? If this is correct it would be great if you could to mark the post as 'Best Answer'!