A new guy at work has shown me how powerful regular expressions are. Following is a trick for formatting the columns names of a SQL table.
Do a query in SQL Query Analyzer on your table like:
SELECT * FROM table WHERE 1=0
Column1 Column2 Column3 Column4
It will return 0 rows. Be sure to return the results as text (ctrl + T), so you can just copy the header row that will have all the field names, separated by a ton of spaces. Paste the results in Notepad++. Open up the replace dialog. Check the "Regular expressions".
"\s" means find any white space. "+" means repeat the previous character until you don't find it anymore.
Replace with \n,
That is a new line and a comma.
The final result is
Notepad++ uses the POSIX regular expression language. I look forward to using it more.
Mormon Consecration was and is Voluntary
1 week ago