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,

 

Number1

 

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

 

'Number1'

 

 

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?

Outcomes