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.