AnsweredAssumed Answered

Importing from Excel, with field changes?

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

Title

Importing from Excel, with field changes?

Post

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

Outcomes