lovelandj

Calculation help

Discussion created by lovelandj on Sep 22, 2014
Latest reply on Sep 22, 2014 by 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

Outcomes