AnsweredAssumed Answered

Script import of a .csv file that uses single quotes?

Question asked by Oliver_Reid on Aug 11, 2012
Latest reply on Aug 13, 2012 by usbc

I have a .csv file that uses single quotes (') , whereas it seems FMP uses double quotes (")


By first importing into Excel, I can do this one time, but I then for additional imports I will have field called, say,




but the import script step will see the header field name in the csv file as





There are hundreds of fields and I want/need to use "matching names" and I need the recrurring import from these files to be a one click step for the user


Note the data itself is all numeric and is not enclosed in quotes. Its the field names in songle quotes that cauaing a probelm.



Any ideas?