3 Replies Latest reply on Nov 29, 2017 3:47 AM by Emma May

    How to filter a field containing a string from a list

    Emma May

      I have 2 list of data, 1 contains a list of item numbers, the second contains (amongst other things) a list of alternative item numbers for the items, this alternative item field can contain 1 item code, or several item codes with different punctuation marks in it as shown in the attached excel & a sample of which is below

       

       

      Part Code
      xlM6R
      7jmXj
      vex8v
      BYUTM
      YirR1
      PY0UR

       

        

      ItemAlternative Codes
      estatedxlM6R; DTegd. MhR0Y
      oversurety7jmXj; RgJ4u. 7jmXj
      switchgirlvex8v
      butterfly
      chehalisYirR1; tLUzW
      momencePY0UR; RaGXR. vex8v

       

      What I would like to do, is find all items, that have the string xlM6R in any place within the Alternative codes field.  I am thinking something to do with parameters, but I am not sure

       

      Is this possible? if so, how?

       

      Many Thanks

      Emma