topic Re: Removing Zeros From a Field in ArcGIS Pro Questions

Removing Zeros From a Field

MichelleCouden — Thu, 14 Mar 2019 20:17:10 GMT

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.

Re: Removing Zeros From a Field

Robert_LeClair — Thu, 14 Mar 2019 20:29:17 GMT

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.

Re: Removing Zeros From a Field

JoeBorgione — Thu, 14 Mar 2019 21:29:07 GMT

In python you can use:

!field_name!.lstrip('0')

That'll strip off any leading zeros:

Re: Removing Zeros From a Field

MatthewDuffy — Wed, 01 May 2019 18:02:55 GMT

Used to be that we could simply multiply the text as a number by 1

000012 x 1 = 12

Trying to find out what this might look like today from within ArcPro is up to you

Re: Removing Zeros From a Field

MatthewDuffy — Wed, 01 May 2019 18:07:14 GMT

Thank you Joe Borgione, this is helpful and I remain grateful for your input

Re: Removing Zeros From a Field

JoeBorgione — Wed, 13 Jan 2021 17:26:37 GMT

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....

Re: Removing Zeros From a Field

DavidWheelock2 — Fri, 25 Jun 2021 14:44:40 GMT

Is there an Arcade solution?

Re: Removing Zeros From a Field

JoeBorgione — Fri, 25 Jun 2021 14:47:19 GMT

Don't know offhand: check here and take a look...