How to make linebreaks in an import - i.e. text for the "Description" field (TinyMCS)?

Great minds think alike  (except I referred to \n as "new line" not "line feed" and I didn't want to confuse anyone with hexadecimal explanations. Escaping is normally complex enough!)

With Excel, it is trickier but possible to enter line breaks in a cell of text. Within a cell, to create a multi-line text you need to hold down the "Alt" key and then press the "Enter" (or "Return") which will create a new line in the cell text rather than move to another cell. You then need to "Save As..." "CSV (MS DOS) *.csv" in order to produce a true text, CSV file. This should then automatically enclose the text within double quote marks (but that option is configurable in Excel if you want to use a different enclosure character such as a single quote).

For avoidance of doubt here, I use Linux as my main O/S for Sugar work - hence my affinity to sed & awk. However, as almost invariably data for migrations will be received from customers in Excel format it is important to know that it can be converted reasonably easily into CSV for importing into Sugar (or other database systems) from that tool as well.

Hope this helps someone,

JH.