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???
... View more