topic Re: Using Field Calculator to Edit Attribute Table in Arc10 in Data Management Questions

Using Field Calculator to Edit Attribute Table in Arc10

ChristopherBlouch — Thu, 07 Jul 2011 17:49:40 GMT

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

Re: Using Field Calculator to Edit Attribute Table in Arc10

juliemorrison — Tue, 19 Jul 2011 17:05:06 GMT

Would you mind sharing the expression that works in Arc version 9.3?

Re: Using Field Calculator to Edit Attribute Table in Arc10

RuthEmerick — Wed, 20 Jul 2011 15:06:24 GMT

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.