Visual Studio has ability to delete empty lines in replace operation using regular expressions.
1.Click Ctrl-H (quick replace)
2. Tick "Use Regular Expressions"
3. In Find specify ^$\n
4. In Replace box delete everything.
5 Click "Replace All"
All empty lines will be deleted.
Regular expression for empty line consist of
|
Beginning of line ^
|
|
|
|
End of line $
|
|
Note that normally in Windows an end of line indicated by 2 characters CRLF - Carriage Return (CR, ASCII 13, \r) Line Feed (LF, ASCII 10, \n).
Addition from at 6/18/2009:
A regex to remove blank lines that are/aren't *really* blank (i.e. they do/don't have spaces): ^:b*$\n
Addition from at 8/5/2011:
To remove double lines: ^:b*\n:b*\n replace with: \n
To delete rows with
single comma
3. In Find specify ^,$\n
For similar requirement to remove comma at the end of lines in text, do the following steps.
1.Click Ctrl-H (quick replace)
2. Tick "Use Regular Expressions"
3. In Find specify ,\r?\n.
4. In Replace box type \n.
5 Click "Replace All"