Hi... new here and to IDEA, I finally found this equation to exclude any Description that contains the word "lease": .NOT. @isini("lease", DESCRIPTION )
My question: how can I write an equation to find and exlude multiple strings? I've tried everything I can think of and none of my attempts are working. For exmaple, I want to exclude any record where Description contains any of the following: lease, concession, ledger, inspection, or insurance. I actually have a total of 33 keywords I want to exclude, this is just a small list for an example. Thank you!
dana48131
Offline
Last seen: 2 months 18 hours ago
Joined: 02/25/2024 - 17:43
.NOT. (@isini("lease", DESCRIPTION ) .OR. @isini("concession", DESCRIPTION ) .OR. @isini("ledger", DESCRIPTION ) .OR. @isini("inspection", DESCRIPTION ) .OR. @isini("insurance", DESCRIPTION ))
Your equation must not exeed 10.000 chars!
edit: missing dot added
Thank you, once I found a missing period, it worked!!!