AnsweredAssumed Answered

Importing carriage returns in a .csv file

Question asked by CarlisleLandel on Jul 10, 2014
Latest reply on Jul 10, 2014 by CarlisleLandel

Title

Importing carriage returns in a .csv file

Post

     I've got some MS word forms, the data in which can be saved as a .csv file, which then gets imported via script.

     How do I get a carriage return in the .csv to import within its text filed reliably?  Sometimes the whole field goes into the correct space, and sometimes the data beyond the carriage return goes into the next field, shifting everything out of register for the rest of the import. I can't figure out the rules the program uses to decide whether to keep the return within a field or shift it into the next.  Does anybody know the trick?

     I'm still using FMP12, by the way.

     Thanks.

Outcomes