Create Leading Zeros
Create leading zeros only for id columns. Please use generic approach!
Start file
id data age parent_id
11 "Test" 12 123
123 "Test2 11 null
155 "Test5 19 123
111 "Test" 12 1123
1123 "Test2 11 11
1155 "Test5 19 1123
211 "Test" 12 123
2123 "Test2 11 11
2155 "Test5 19 123
2111 "Test" 12 1123
3123 "Test2 11 11
3155 "Test5 19 1123
1 "root" 9 null
End file
id data age parent_id
0011 "Test" 12 0123
0123 "Test2 11 null
0155 "Test5 19 0123
0111 "Test" 12 1123
1123 "Test2 11 0011
1155 "Test5 19 1123
0211 "Test" 12 0123
2123 "Test2 11 0011
2155 "Test5 19 0123
2111 "Test" 12 1123
3123 "Test2 11 0011
3155 "Test5 19 1123
0001 "root" 9 null
View Diff
2,6c2,6
< 11 "Test" 12 123
< 123 "Test2 11 null
< 155 "Test5 19 123
< 111 "Test" 12 1123
< 1123 "Test2 11 11
---
> 0011 "Test" 12 0123
> 0123 "Test2 11 null
> 0155 "Test5 19 0123
> 0111 "Test" 12 1123
> 1123 "Test2 11 0011
8,10c8,10
< 211 "Test" 12 123
< 2123 "Test2 11 11
< 2155 "Test5 19 123
---
> 0211 "Test" 12 0123
> 2123 "Test2 11 0011
> 2155 "Test5 19 0123
12c12
< 3123 "Test2 11 11
---
> 3123 "Test2 11 0011
14c14
< 1 "root" 9 null
---
> 0001 "root" 9 null
Solutions
The best way to learn is to practice. Below, you will find some of the solutions other golfers have entered. To unlock higher ranked solutions, submit your own entry which does as well or better than the solutions you can currently see - climb the ladder!
Check out these helpful resources to improve your Vim skills... Game on.
Unlock 81 remaining solutions by signing in and submitting your own entry
#82 RobertT / @techrt2050 - Score: 127 - 10/10/13 @ 00:55
:v/null/s/\t\([0-9]\)$/\t000\1<CR>:<Up><Left><Left><BS><Left><Left><Left><Left><Left><Left><Left><Left>[0-9]<CR>:<Up><Left><Left><BS><Left><Left><Left><Left><Left><Left><Left>[0-9]<CR>:v/^id/s/^\(.\)\t/000\1\t<CR>:<Up><Left><Left><Left><Left><BS><Left><Left><Left><Left><Left><Left><Left>.<CR>:<Up><Left><Left><Left><Left><BS><Left><Left><Left><Left><Left><Left>.<CR>ZZ
0 comments