[GIS] Field Calculate to remove certain values in field

arcgis-10.2arcgis-desktopfield-calculatorpython-parser

I have a field named "ZIP" which has the zip code information for numerous records. Some of them have 9 numbers, but I only want them to have the first 5. What should my Pre-Logic Script look like to Field Calculate removing the last 4 numbers in this field?

Here is an image of the Field Calculator and the field:

Best Answer

Use the string indices. Instead of creating a whole function, just do something like:

!ZIP![:5] --> basically grab everything from 0 index up to but not including the 5th index.

So it only grabs the indices 0,1,2,3,4.

Check out this tutorial for more information.

If there are more than 5 it will just grab the first 5. If there are 5 exact, it will grab them.

Related Solutions

[GIS] How calculate sequential values based on group field

You can do this with an UpdateCursor easily in the Python Window:

import arcpy

vals = []
fields = ['ORDER_ID', 'GROUP_ID'] #your field names
with arcpy.da.UpdateCursor(your_lyr, fields) as rows:
    for r in rows:
        vals.append(r[1])
        r[0] = vals.count(r[1])
        rows.updateRow(r)

where the your_lyr variable is a reference to the table you're updating.

[GIS] ArcMap Field Calculator Remove Null values

Im sure this is Python and not VB script. By putting the 0 in speech marks, you are trying to say that 0 is a string, when its not. As added by Martin, please select the Python Parser instead of the VB Script Parser. Try and use the following code:

def RemoveNULL(x):
  if x is None:
    return 0
  elif x == ' ':
    return 0
  else: 
    return x

Best Answer

Related Solutions

[GIS] How calculate sequential values based on group field

[GIS] ArcMap Field Calculator Remove Null values

Related Question