Hi all,
I’ve got this line which mostly works:
=IIf( InStr( [AMProdStep.Descr], 'MESH' )<0, IIf( InStr( [AMProdStep.Descr], 'ADHESIVE' )<0, True, False ), False)
We don’t want anything with ‘ADHESIVE’ in the product description to print and it works fine. But now we have one adhesive type we do want to print, let’s say ‘BLUE ADHESIVE’… how do I restrict all adhesives from printing but allow BLUE ADHESIVE to make it through the expression?
Best answer by lauraj46
Hi
I think this would do it:
=IIf(Instr([AMProdStep.Descr], 'MESH')>0 or
(Instr([AMProdStep.Descr], 'ADHESIVE')>0 and Instr([AMProdStep.Descr], 'BLUE ADHESIVE')<0), False, True)
+8Hi
I think this would do it:
=IIf(Instr([AMProdStep.Descr], 'MESH')>0 or
(Instr([AMProdStep.Descr], 'ADHESIVE')>0 and Instr([AMProdStep.Descr], 'BLUE ADHESIVE')<0), False, True)
Hi
I think this would do it:
=IIf(Instr([AMProdStep.Descr], 'MESH')>0 or
(Instr([AMProdStep.Descr], 'ADHESIVE')>0 and Instr([AMProdStep.Descr], 'BLUE ADHESIVE')<0), False, True)
Laura you’re a peach, that worked perfectly… this will help me begin parsing how I can write my own expressions… thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
