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 réponses
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'!