column expression, not contains
Dear all,
I have a column expressxion with an complex if statement:
if
(
(left(column(“SerialNo”),3 ) == “111”) &&
(contains(upperCase(column(“ObjectSubEquipmentDescription”)), “1K/2C”)) &&
(contains(upperCase(column(“ObjectDescription”)), “2XCOMP”))
)
{
replace(column(“ObjectDescription”),“1xCOMP” ,“2xCOMP” )
}
else
{
column(“ObjectSubEquipmentDescription”)
}
How do I have to write does not contains instead of contain in the last expression of if statement?
(contains(upperCase(column(“ObjectDescription”)), “2XCOMP”))
like
(not contains(upperCase(column(“ObjectDescription”)), “2XCOMP”))
Thx for help!
BR,
Heinz