Script to change field names
I have a database that was not created in the best way. It tracks user productivity and therefore has roughly 30 fields per each user. Field names for example are C.Horgan_HR_Step1, C.Horgan_HR_Step2 etc, where C.Horgan is a user. Now I need to change the user name. I want to change the field names where every instance of "C.Horgan" changes to "A.Chavez" but leaves the remaining filed name alone. Any suggestions?