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

I would suggest adding \r\n instead of <br> and/or <p> into the text that you are importing from. I think that should give you the expected results.

The field description in your emails_text table is what you see on the screen when you open up to read an email. To insert a linebreak into an sql table, you need \r\n\

I would suggest adding \r\n instead of <br> and/or <p> into the text that you are importing from. I think that should give you the expected results.

The field description in your emails_text table is what you see on the screen when you open up to read an email. To insert a linebreak into an sql table, you need \r\n\

Excellent idea, Viktor Ranga  Tried it but still no line break:

Any other ideas?

Thanks, KGM

If you want to import linefeeds (\n, not "\n") you must produce them in your csv input file.

To do that you must make sure that all fields are encapsulated by quotes or apostrophes.

With Excel it an be difficult to create such files, Libre Office normally works.

Such a csv file looks (e.g. in Notepad++):

"firstname","lastname","description
with a line break or
even two","other data"

"fistname2","lastname2","description without break","other data2"

\n is a unix synonym for the hexadecimal character 0x0a which means "line feed"

\r is the unix synonym for the hexadecimal character 0x0d which means "carriage return"

in Unix \n is used to terminate lines, in Windows \r\n