6 Replies Latest reply: Jun 26, 2015 6:25 AM by laura howarth RSS

    Return everything before number in a string

      Hi,

       

      i have an alphanumeric field where i want to return everything left and including the first number.

       

      For example.

       

      Field1

      Java 3 patch 1

      Java 6 version

      Java patch 3

      Java 7 version

      Java 7 (TM) 123

       

      i want to return

       

      Field1

      Java 3

      Java 6

      Java patch 3

      Java 7

      Java 7

       

      i think i need to use the left and the subfield functions but i don't know how to say return anything left of the first number you find.

       

      Any help would be great.

       

      thanks