2 Replies Latest reply on Sep 22, 2014 10:35 AM by lovelandj

    Calculation help

    lovelandj

      Hello,

       

      Looking for som help with a calculation.

       

      I have numbers with leading zero's I need to be able to strip them away. Here is the catch I have some that have 1 or 2 leading zeros and some that could have more than 2 but no more than 6 leading zeros.

       

      001234500

      000236700

      000000999

      098734500

      754329743

      623497464

      039577203

      008457473

       

      I will need them to look like this

       

      1234500

      236700

      999

      98734500

      754329743

      623497464

      39577203

      8457473

       

      It is one field in the Database.

       

      If there is a better way than a calculation, I am open to sugestions.

       

      Thanks

      Jeremy