1 Reply Latest reply on Jul 12, 2017 4:55 PM by Chris McClellan

    If does not contain statement

    Corey Christensen

      Hi!

       

      I am trying to create a If statement for part numbers, I want only part numbers the have wildcard which I believe is * and the letters HR.  I have tried the below:

       

      IF [Item (MCN)] ENDSWITH("*HR") THEN TRUE END

       

      IF [Item (MCN)] CONTAINS("*HR") THEN TRUE END

       

      IF [Item (MCN)] ENDSWITH("TR") THEN NULL END  ( I tried to remove all the TR part numbers)

       

      Any help would be greatly appreciated, I am still learning as I go.  Headfirst!