Hello there, I have made it using two regexs within AND: one contains the things you are looking, and the other has another regex looking for the things you do not want to be after you were looking before. I've used the NOT in the second REGEX:
For example:
=AND
(REGEXMATCH(B2;"\bAs\b");NOT(REGEXMATCH(B2;"\bAs (if|success|failure|long|such|\w+ as)\b")))
It looks for any text containing
As that is not followed by
if or
success or
failure or
long or
such or
any word plus as.
I think this way is much better than normal negative lookahead.
El dia divendres, 2 de desembre de 2016 a les 21:21:16 UTC+1, adonovan va escriure: