2 Replies Latest reply on Oct 26, 2014 6:33 PM by philmodjunk

    Is there an easier way to clone a data table and then edit the field names?

    BrendaSchick

      Title

      Is there an easier way to clone a data table and then edit the field names?

      Post

      I have a project where I have data tables of 500+ fields for Units 1-3, 4-6, 7-9 etc.  

       

       

       

      I just finished cleaning up 1-3 from a research assistant.

      There are a lot of changes I would need to make to clone 1-3 to 4-6.   Is there an easier way to do this other than editing 500 fields for 3 tables X 500.   Could I just export 1-3 to Xcel, then edit and then import into FMP?

      Are there other ways to bulk search and replace?  

      Brenda