Anyone remember how to remove zeros from in front of a number in a field. For example, I have 00012. I want 12.
I forgot the formula in the field calculator.
Don't know offhand: check here and take a look...
Is there an Arcade solution?
This thread popped up in my activity log today. You can do the same calculation in pro as I described above or use the int() function :
I guess the int() function would have worked originally too....
Thank you Joe Borgione, this is helpful and I remain grateful for your input
Used to be that we could simply multiply the text as a number by 1
so
000012 x 1 = 12
Trying to find out what this might look like today from within ArcPro is up to you
In python you can use:
!field_name!.lstrip('0')
That'll strip off any leading zeros:
I found this bit of code on the Microsoft Community page that should work in the Field Calculator using VBScript:
Assuming there is no space character in the data:
Replace( LTRIM(Replace( fieldName, "0", " ")), " ", "0")
The part in bold replace all zeros by spaces, and then, left-trim that result, ie, remove starting spaces. The external Replace replaces the spaces left in the string to their initial 0 character.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
