Using Field Calculator to Edit Attribute Table in Arc10

1364
2
07-07-2011 10:49 AM
ChristopherBlouch
New Contributor
I am working with parcel data in the State of New Jersey that is classified by Block and Lot. Unfortunately the data I received does not have a standard format. Some of the Block and Lot numbers appear as the should (ex. Block: 1.01, Lot: 5.02) but others appear with leading zeros and spaces (ex. Block 00001  01, Lot: 00005  02). I know that there is an expression that can be entered into the Field Calculator that will remove the leading zeros and spaces, however the expression that I know works in Arc version 9.3 and I am currently working in version 10. Anyone know of an expression I can use???
Tags (2)
0 Kudos
2 Replies
juliemorrison
New Contributor
Would you mind sharing the expression that works in Arc version 9.3?
0 Kudos
RuthEmerick
New Contributor II
You can use python's string method lstrip to do this with the field calculator. See http://docs.python.org/release/2.6.6/library/stdtypes.html#string-methods for information on how lstrip works.
0 Kudos