7 Replies Latest reply: Dec 7, 2017 5:15 AM by Fabio Porta RSS

    How To Remove Leading Zeros in a Number


      Hi All,

       

      I have a field with the following values

      00000978

      00001524

      00001024

      00012356

       

      The field is in number format.

      The length of the field is constant and it is 8.

      I would like to remove the leading zeros and would like to have the values as follows:

      978

      1524

      1024

      12356

       

      Kindly help me to get the above output.

       

      Thanks in Advance!!

       

      Regards,

      Vinitha.