lindsybentleyutah.blogspot.com

One of the most common tasks associated with addresses, is how to pull the house number out of an address. First, create a new field in your data.  Name it House_Number. Next, copy the parcel address into this new field. Then, if you haven't done so already, start an edit session. Open Field Calculator for House_Number.  Using VBA type:            split([field], " ")(0) This is telling the field to delete everything after the first space, giving you the house number. Happy GIS-ing! Lindsy Bentley

In ArcMap, here is how you can calculate sequential numbers using Field Calculator. Set field calculate to python. Paste this in pre logic script: rec=0 def autoIncrement():  global rec  pStart = 1   pInterval = 1  if (rec == 0):    rec = pStart   else:    rec += pInterval   return rec Paste this in second box autoIncrement() Check out one of my other posts about how to Convert from Degrees Minutes Seconds to Decimal Degrees in Python here . Happy GISing! Lindsy Hales Bentley

Here’s a little function to pull numbers out of a string. import re def calculate(value):   newVal = re.sub("[^0-9]", "", value)   if newVal == "":     return 0   elif newVal is None:     return 0   else:     return newVal calculate( !Size! ) Happy GISing! Lindsy Hales Bentley