I am creating a CSV file with google app scripts and then importing this into filemaker pro 11.
the format is something like:
for an example like:
Tue Oct 30 2012 15:35:39 GMT+1100 (EST),john,doe,31/1/1930/,I really like choc chip cookies, etc
It works perfectly.
Because there are several comment fields that allow multiple lines on the user form however, some times google scripts spits out a CSV of the form:
Tue Oct 30 2012 15:35:39 GMT+1100 (EST),john,doe,31/1/1930/,I really
When the later is imported into filmaker pro 11 I am seeing a new record being produced for each line. In cases where there is a blank line an entire blank record is being produced.
Is there a way for me to fix this internally in filemaker pro or do I have to solve the problem at the google script end?
thanks for any help!