We need to import about 100 large CSV files into FMP.
Q1: Of course I prefer to import directly from the CSV file (instead of via Excel). I know about the import file command, but FMP seems to know only comma delimited, not semicolon-. Result is records with a long string in the first field only.
Script ref guide gives nothing useful reg CSV. Not possible in any way to import directly from CSV file?
Q2: if it IS possible, is there also a way to let a script unzip the files automatically?
All suggestions welcome and thanks in advance!