Hi Jake,
Thanks for the quick response and script. I tried using this script that you provided by replacing "parcels" with the path to my feature class. I then added this script into ArcToolbox and ran it. The ran successfully, but when I opened the feature class, the extra spaces did not appear to get removed. Is there anything else that I am missing? Thanks again!
You said that post 2 worked for you, but only on a single feature. You can combine the two and use that same coding on the entire FC if you want. something like this:
arcpy.MakeFeatureLayer_management("C:/data.gdb/parcels", "parcels_lyr")
for field in arcpy.ListFields("parcels_lyr", "*", "String"):
sqlFieldName = arcpy.AddFieldDelimiters("parcels_lyr", field)
calcSql= "' '.join( field.strip().split())"
arcpy.CalculateField_management("parcels_lyr",field,calcSql,"PYTHON_9.3","#")
This seems to do it for me.R_If you wanted to use cursors, post 4 could be used, but use this calc function instead.