suppressing a field with like??

[jorg32]

Hi,

Is it possible to suppress a field when it find just a part of a word or phrase?

eg : article = '123456_OMS'
--> suppress when article ended with '_OMS' or suppress when '456'

thanks for helping me.

JM

 

[dswitzer]

I'm no expert - and have no idea if there is any "like" statement. But try using instr to search for your string -- if it is not found, the function returns zero.

 

[mbarron]

For your conditional suprression formula you can use:

if {article} like "*OMS" then true else
if {article.field} like" *456*" then true else
false

Mike