How do you remove embedded newlines in a CSV document?

A CSV cell can contain an embedded newline. When a newline is embedded, this means that a newline character is included in a cell. The double quotes ("") are used to escape delimiters and newlines within a cell, and this allows delimiters or newline characters to be included in a cell.

In EmEditor, the embedded newline appears as a M and/or J with black backgrounds. M represents a carriage return and J represents a line feed.

Embedded newline

When opened in Normal Mode, the text is as follows:


If you want to remove these embedded newlines but keep newlines that separate rows, go to CSV | Advanced | Remove Embedded Newlines. After using this command, the file now looks like: