Thursday, 29 June 2017

How to remove empty lines in text In Visual Studio?

Visual Studio has ability to delete empty lines in replace operation using regular expressions.
  • Click Ctrl-H (quick replace)
  • Tick "Use Regular Expressions"
  • In Find specify ^$\n
  • In Replace box delete everything.
  • Click "Replace All"
All empty lines will be deleted.
Regular expression for empty line consist of
Beginning of line ^
End of line $
Line break \n


1 comment:

Resetting IDENTITY Seed in Table Variable

For a "normal" table, you would use:  DBCC  CHECKIDENT( ' [table_name]' , RESEED, [new_reseed_value]). you cannot reseed...