Real Vim ninjas count every keystroke - do you?

Pick a challenge, fire up Vim, and show us what you got.

Changelog, Rules & FAQ, updates: @vimgolf, RSS.

Your VimGolf key: please sign in

$ gem install vimgolf
$ vimgolf setup
$ vimgolf put 9v0066d8266e000000000367

Search different SQL column with similar where clause

Replace a column in the where clause and convert all numbers from text to numeric, by replacing the leading 0 with the code 359.

Start file
SELECT * FROM numbers WHERE local_number IN (
       
"058307327",
       
"058307328",
       
"058307329"
)
End file
SELECT * FROM numbers WHERE int_number IN (
       
35958307327,
       
35958307328,
       
35958307329
)

View Diff

1,4c1,4
< SELECT * FROM numbers WHERE local_number IN (
<       "058307327",
<       "058307328",
<       "058307329"
---
> SELECT * FROM numbers WHERE int_number IN (
>       35958307327,
>       35958307328,
>       35958307329

Solutions by @rasputins:

Unlock 9 remaining solutions by signing in and submitting your own entry
Created by: @stoyandimov

59 active golfers, 258 entries

Solutions by @rasputins:
22
#9 - rasputins / @rasputins

10/21/2024 at 05:18PM

23
#>22 - rasputins / @rasputins

10/21/2024 at 05:15PM

24
#>26 - rasputins / @rasputins

10/21/2024 at 05:11PM

25
#>31 - rasputins / @rasputins

10/21/2024 at 04:14PM

26
#>34 - rasputins / @rasputins

10/21/2024 at 04:13PM

27
#>38 - rasputins / @rasputins

10/21/2024 at 04:11PM

28
#>43 - rasputins / @rasputins

10/21/2024 at 04:09PM

29
#>46 - rasputins / @rasputins

10/21/2024 at 04:08PM

43
#>56 - rasputins / @rasputins

10/21/2024 at 04:05PM