look at that...I learn something new today.... :s/\t/,\r/g
I didn't know that one...thanks On 09/24/2012 10:36 AM, Tim Chase wrote: > On 09/24/12 12:19, vicky b wrote: >> Thanks for the replies guys but in the present world where we >> leave with so much of ide and code completion and so many >> features what is that makes you guys stick to vim .. does it make >> your job simpler or features are great or your use to it. > First, I've used Vim for so long that I now find things like ":w" > appearing in my other editing tools (Query Analyzer, Word, etc), so > using Vim is habit. > > Also, the power of Vim makes it very easy to perform quick > transformations on text/queries which I regularly do. For DB work, > one I frequently do is a > > SELECT TOP 1 * FROM SomeTable > > and run it in text-mode (rather than grid-mode). I then copy out > the headers in the results, paste them into Vim and issue a > > :s/\t/,\r/g > > to turn them into named columns that I can order as I see fit, > without hand-entering them all. That often makes the foundation of > a SELECT clause for me. > > Matching parens/braces, syntax highlighting, batch transforms, > macros, etc. are all reasons I have trouble stepping away from Vim. > > -tim > > > > -- You received this message from the "vim_use" maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
