Importing carriage returns in a .csv file
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.