Looking for a expression that show me true for keywords inside a value

16 views Asked by At

I want a expression that filter keywords inside a text value.

I created this expression:

or(value.contains('ONIBUS'), value.contains('ÔNIBUS'), value.contains('COLETIVO'), value.contains('DENTRO'))

But i want something like this:

if(or(value.contains('ONIBUS'), value.contains('ÔNIBUS'), value.contains('COLETIVO'), value.contains('DENTRO')) and value.notcontains('DESCENDO'), TRUE, FALSE)

Create a Column

0

There are 0 answers