topic Re: Removing Characters from table in New to GIS Questions

Removing Characters from table

WilliamRice1 — Thu, 17 Jul 2014 20:00:04 GMT

I am trying to use the field calculator to remove text in a data table. All of the addresses have (6) zero's in front of the address and I am trying to remove them. I am using arcmap 10.1 with a standard license.

Can someone tell me how to remove the first 6 characters in each entry.

Re: Removing Characters from table

BrandonColeman — Thu, 17 Jul 2014 20:08:31 GMT

Using the field calculator, you should just make a new string without the 6 zeros.

Try something like...

!FieldName!.replace("000000", "") -- if 6 zeros only exists once in each record

!FieldName![5:] ‌--this should pull all characters past the 6th character to the end

Check these for more help

ArcGIS 10 Python split string - Geographic Information Systems Stack Exchange‌

ArcGIS Desktop --this may be better‌

Re: Removing Characters from table

DanPatterson_Retired — Thu, 17 Jul 2014 20:23:24 GMT

actually

>>> a = '00000012345'

>>> a[6:]

'12345'

>>>

Re: Removing Characters from table

BrandonColeman — Thu, 17 Jul 2014 20:26:32 GMT

Thanks for the correction. At least I had the idea right.

Re: Removing Characters from table

StevenGraf1 — Thu, 17 Jul 2014 20:32:15 GMT

Find and replace would be easier. You don't need any code.