3 Replies Latest reply on Sep 12, 2013 7:23 AM by Alex Kerin

    How can I search in txt to create another field?

    Cristina Palo

      I've looked at several other posts but can't seem to figure out this one...I have several product names containing description, size, UPC, etc

       

      I want to isolate the size, which position always vary in the txt. Below are some examples:

       

      ABREVA CLD SR FVR
        BLST TRTM CREAM PEG CARD PUMP 0.07OZ 0766080155
      CABOODLES LIP JELLY
        PINK LEMONADE LIP BALM JELLY 0.3OZ 6724529408
      LYPSYL ALOHA LIP
        BALM STICK 0.15OZ 6799000700
      CARMEX CLICK STICK
        CHERRY LIP BALM STICK 0.15OZ 8307800030

       

      The one think all of them have in commom is the "OZ" as a measure. and there is no space between the numbers and OZ. Also hte UPC is always 10 characters counting from right to left....

       

      Can anyone help please?

       

      Thank you!!

       

      Cristina