6 Replies Latest reply: May 15, 2014 10:08 AM by Nick Osdale-Popa RSS

    string operation

      Hi,

       

      i`m looking for something which gives me 2 cases of string elements:

      In column is something like that unsorted:

       

      ABCDEF

      ERTZUI

      TZUIOEP

      UIORTZP

      UIORTZM

      TZUIOE

      ABCDEFZ

      ABCDEFUI

       

      What i`d like to recieve, is are strings which are 6 or 7 characters long, and if 7 it must end with "P". Notice: Elements in source could be max. 10 characters long.

       

      Any ideas?

       

      Best regards

      Rolf