Menu
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?
494
In the Find box hold down the Alt key and type 0 1 0 for the line feed and Alt 0 1 3 for the carriage return. They can now be replaced with whatever you want.
On the Edit menu, point to Find and Replace, and then click Quick Find to open the dialog box with find options, but without replace options. On the Edit menu, point to Find and Replace, and then click Quick Replace to open the dialog box with both find options and replace options.
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
186
You can do a regular expression find and replace on \x0d\x0a, which represents a line break.
28
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
