2 Replies Latest reply on Jun 1, 2009 8:17 PM by davidanders

    Script to change field names

    Jon1

      Title

      Script to change field names

      Post

      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?

       

      Thanks,

       

      Jon