2 Replies Latest reply on Sep 15, 2009 1:55 PM by Karnel

    removing numbers in existing data

    Karnel

      Title

      removing numbers in existing data

      Post

      I need to remove zeros from a set of numbers in a text field.  The number is exactly eight characters but the number of zeros vary. 

       

      For example: 

       

      00000285

      00009796

      00536005

      01250308

       

      Is there a way to strip the zeros proceeding the numbers in this field?

       

      Thanks in advance!