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

    Return everything before number in a string



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


      For example.



      Java 3 patch 1

      Java 6 version

      Java patch 3

      Java 7 version

      Java 7 (TM) 123


      i want to return



      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.