Regex to match anything, string, multiple,strings including newline non greedy in VIM

Question

I want to replace lowercase strings within:

SELECT lower1, lower2, lower3 FROM lower4, lower5 WHERE

I use vim replace to replace them to upper case with this regex:

:%s/select\_.*\from\_.*\where/\U&/gic

The regex select\_.*\from\_.*\where is not good when there are other select queries:

for example it selects everything in this query and affects the strings that cannot be uppercased

SELECT lower1, lower2, lower3 FROM lower4, lower5 WHERE lower1=cannot_be_uppercased
UNION all
SELECT lower1, lower2, lower3 FROM lower6, lower7 WHERE lower1=cannot_be_uppercased

Are you trying to lower case everything but the SQL keywords? — JaredPar, Feb 21 '12 at 06:17
What's wrong with your regex? When I tried it on your examples, it seems to do what you requested. — Stephen Quan, Feb 21 '12 at 06:33
I'm not sure what you expect, but maybe you want to use non-greedy quantifiers \{-} instead of the greedy one *. — Raimondi, Feb 21 '12 at 06:55
I only want to select the first SELECT ... FROM .. WHERE SELECT lower1, lower2, lower3 FROM lower4, lower5 WHERE — bbnn, Feb 21 '12 at 07:51
See http://stackoverflow.com/questions/1305853/how-can-i-make-my-match-non-greedy about vim and non-greedy matching. — Randy Morris, Feb 21 '12 at 11:23

score 1 · Accepted Answer · answered Feb 21 '12 at 10:49

There is non-greedy mode in vim regex. Instead of use *, use \{-}.

The regex select\_.\{-}from\_.\{-}where , as I think, is what you want.

Here is some docs.

:h non-greedy

                            *non-greedy*
If a "-" appears immediately after the "{", then a shortest match
first algorithm is used (see example below).  In particular, "\{-}" is
the same as "*" but uses the shortest match first algorithm.  BUT: A
match that starts earlier is preferred over a shorter match: "a\{-}b"
matches "aaab" in "xaaab".

Example         matches ~
ab\{2,3}c       "abbc" or "abbbc"
a\{5}           "aaaaa"
ab\{2,}c        "abbc", "abbbc", "abbbbc", etc.
ab\{,3}c        "ac", "abc", "abbc" or "abbbc"
a[bc]\{3}d      "abbbd", "abbcd", "acbcd", "acccd", etc.
a\(bc\)\{1,2}d      "abcd" or "abcbcd"
a[bc]\{-}[cd]       "abc" in "abcd"
a[bc]*[cd]      "abcd" in "abcd"

The } may optionally be preceded with a backslash: \{n,m\}.

Regex to match anything, string, multiple,strings including newline non greedy in VIM

1 Answers1