Note: these tools requires an active ArcGIS license.

 

ArcCatalog toolset to clean up & standardize text fields in a geodatabase. Intended to be used as an ArcCatalog Script Tool: to implement create toolbox with one script tool for each script, each taking a single Feature Class as input.

attrib_cleaner.py: A quick script to clean up & standardize text fields in a geodatabase. Mixed-case strings will be converted to all-uppercase with extra leading/trailing spaces removed. Empty field conversion errors (e.g., string "NULL" in place of no-value) will be replaced with None/database null values.

nuller.py: Can be used as a separate tool to null empty text fields only -- or can also be used inside Field Calculator logic while using ArcMap. Replaces empty or space-only strings with None (database Null) values. Useful in cases where text fields contain one or more spaces in lieu of no-value.