Importing from Excel, with field changes?
I need to import periodically from an Excel spreadsheet, but the data in the spreadsheet is not in exactly the same format I want in FMP. For example, spreadsheet has an address of "123 N Main St" and I want this to go into FMP table as street number "123" and street name "N Main St".
Is there a way I can automate this in FMP or must I massage the spreadsheet first and create additional columns?
(I am using FMP 13. I have not used FMP since v4, so am very rusty!)