AnsweredAssumed Answered

Importing from Excel, with field changes?

Question asked by guyscharf on Jun 5, 2014
Latest reply on Jun 6, 2014 by philmodjunk


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!)