AnsweredAssumed Answered

Script to change field names

Question asked by Jon1 on Jun 1, 2009
Latest reply on Jun 1, 2009 by davidanders


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?