Script to generalize text in new attribute field?

Discussion created by ecoburks on Jul 24, 2012
Latest reply on Jun 5, 2013 by rangermry
I have a parcel database with about 25,000 property owners. Some property owners are coded differently in the ownership field, for example "John Smith" and "Smith John" or "Univ of CA" and "University of California" are the same owners but were coded slightly differently.

Is there a script where I can update text to create a new, generalized field in my attribute table? For example, is there a way to convert all "Univ of CA" and "University of California" records into "University of California" in a new field, automatically?

Ultimately I want to run a Dissolve on the property owner field to create a shapefile that shows tracts of land-ownership, but I need to create the generalized ownership field before I execute the Dissolve. I also have an address field in the attribute table so I know which parcels are actually owned by the same person and not different people with similar names.

Any ideas? Thank you very much for your time.