1 Reply Latest reply: Dec 19, 2017 11:43 AM by Massimo Grossi RSS

    Substring question

    Thierry Van Impe

      Hello , 

      Is it possible to know how to extract a sub string in a new field for the following scenario :   

      The content of my field is only numeric or numeric following by alphabetical  characters  


      example  :        12345            result will be  12345   

                               12345ABC     result will be 12345  

                               12345Z          result will be 12345  

      Thanks for your help