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.
Solved! Go to Solution.
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
actually
>>> a = '00000012345'
>>> a[6:]
'12345'
>>>
Thanks for the correction. At least I had the idea right.
Find and replace would be easier. You don't need any code.