Is there an easier way to clone a data table and then edit the field names?
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?