Remove Extra Spaces when Pasting from Outlook to Sql Server Management Studio
I seem to have this problem that when I paste sql code from my email into Sql Server Management Studio that it doubles all the line breaks and I have to go and remove them all. Most of the time this isn't a big deal because the Sql is only a couple lines. However if you get a ton of Sql emailed to you it can be quite annoying. I finally found a way to quickly get rid of them. Simply bring up the find and replace window and change the find to use Regular Expressions. Then do a find on \n\n and replace that with \n.
No comments:
Post a Comment