Great VIM regexp tutorial
- Read more about Great VIM regexp tutorial
- Log in to post comments
Just a (great) reference: http://vimregex.com/
Read it = love it!
Vim regexp: transforming multiple SQL inserts into a big one
If you ever face a very slow MySQL process based on a very long insert file and you want to optimize it by unifying a lot of queries, you can do something like the following.
Imagine you have a lot of these:
Quick Perl Regexp in VIM to format e-mails list
I have a list of e-mails that I extracted from MySQL as something like this:
name@example.com firstname lastname
name2@example.com firstname2 lastname2
name3@example.com firstname3 lastname3
and I want them to be in this format:
firstname lastname
firsntame2 lastname2
firstname3 lastname3
Using VIM, I can do:
:% s/^/ /
:% s/()s(w*)s(.*$)/2 3 1/
The last one is a bit more complex but uses the n-style references to parenthesed elements in the matching part.
Quick Perl Regexp in VIM to format e-mails list
I have a list of e-mails that I extracted from MySQL as something like this:
name@example.com firstname lastname name2@example.com firstname2 lastname2 name3@example.com firstname3 lastname3and I want them to be in this format:
firstname lastname <name@example.com> firsntame2 lastname2 <name2@example.com> firstname3 lastname3 <name3@example.com>Using VIM, I can do:
:% s/^/</ :% s/s/> / :% s/(<.*>)s(w*)s(.*$)/2 3 1/The last one is a bit more complex but uses the n-style references t