How to replace a character by a line break in VS or SQL Server Management Studio

Question

How to replace a character (or many characters) by a line break in VS or SQL Server Management Studio using the Find and Replace dialog?

Answer 1

You can do a regular expression find and replace on \x0d\x0a, which represents a line break.

Answer 2

At the bottom of the "Find and Replace" dialog, check the box "Use" and select "Regular expressions"

Then in the "Replace with" box put \n