VimGolfUgly spreadsheet copy/paste to CSV
convert an ugly spreadsheet copy/paste into a CSV format.
Start file
TIANJIN DALIAN HUANGPU NINGBO QINGDAO SHANGHAI SHANTOU SHENZHEN WUHAN HONG KONG HAIPHONG 885 885 910 860 885 860 1080 860 1040 860 935 1585 1585 1635 1535 1585 1535 1885 1535 1860 1535 1795 1710 1710 1760 1660 1610 1660 2010 1660 1985 1660 1920
End file
TIANJIN,885,1585,1710 DALIAN,885,1585,1710 HUANGPU,910,1635,1760 NINGBO,860,1535,1660 QINGDAO,885,1585,1610 SHANGHAI,860,1535,1660 SHANTOU,1080,1885,2010 SHENZHEN,860,1535,1660 WUHAN,1040,1860,1985 HONG KONG,860,1535,1660 HAIPHONG,935,1795,1920
View Diff
1,47c1,11 < TIANJIN < DALIAN < HUANGPU < NINGBO < QINGDAO < SHANGHAI < SHANTOU < SHENZHEN < WUHAN < HONG KONG < HAIPHONG < < 885 < 885 < 910 < 860 < 885 < 860 < 1080 < 860 < 1040 < 860 < 935 < < 1585 < 1585 < 1635 < 1535 < 1585 < 1535 < 1885 < 1535 < 1860 < 1535 < 1795 < < 1710 < 1710 < 1760 < 1660 < 1610 < 1660 < 2010 < 1660 < 1985 < 1660 < 1920 --- > TIANJIN,885,1585,1710 > DALIAN,885,1585,1710 > HUANGPU,910,1635,1760 > NINGBO,860,1535,1660 > QINGDAO,885,1585,1610 > SHANGHAI,860,1535,1660 > SHANTOU,1080,1885,2010 > SHENZHEN,860,1535,1660 > WUHAN,1040,1860,1985 > HONG KONG,860,1535,1660 > HAIPHONG,935,1795,1920
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 79 remaining solutions by signing in and submitting your own entry
#80 Kevin Hansen / @coolwebteacher - Score: 51 - 05/09/12 @ 14:26
Q%s/^\d/,&<CR>g/^\w/m/^$|j!|m/^$|j!|m/^$|j!|m$<CR>1,3d|x<CR>
0 comments
#81 Ben Friedland / @bfriedland174 - Score: 51 - 05/23/12 @ 21:34
qq:m $<CR>5(:m $<CR>3(@:(@:3k4Jggq10@qd2j:%s/ /,/g<CR>kwr ZZ
0 comments
#82 Jordan Scales / @prezjordan - Score: 51 - 08/17/12 @ 18:58
qq12jD12k$a,<Esc>p24j^D24k$a,<Esc>p36j^D36k$a,<Esc>pj^q10@qdGZZ
0 comments
#83 bsjd / @bsjd - Score: 53 - 05/07/12 @ 14:14
:%s/^\d/,&<CR>:g/^$/d<CR>qq:v/\a/norm d2aw11k$p<CR>q2@q12GdGZZ
0 comments
#84 utopiah / @utopiah - Score: 53 - 06/11/12 @ 02:50
qq:m $<CR>5(:m $<CR>3(@:(@:3k4Jggq10@qd2j:$<BS>%s/ /,/g<CR>kwr ZZ
0 comments
#85 James Freed / @JamesTFreed - Score: 54 - 02/03/12 @ 15:04
qwA,<Esc>pqxqq12jdaw12k@w24jdaw24k@w36jdaw36k@w<CR>q10@qdGGZZ
0 comments
#86 Omer Rauchwerger / @rauchy - Score: 54 - 02/18/12 @ 02:02
qwA,<Esc>pqxqq12jdaw12k@w24jdaw24k@w36jdaw36k@w<CR>q10@qdGGZZ
0 comments
#87 Viktor Jackson / @AntiStalinista - Score: 56 - 05/04/12 @ 23:23
:g/^$/d<CR>:v/\a/norm I,<CR>qq:v/\a/norm d2aw11k$p<CR>q2@q12GdGZZ
0 comments
#88 cromac / @cromac - Score: 56 - 07/09/12 @ 18:54
qama/^$<CR>jdd'aA,<Esc>pkJxjq10@addgg11@agg:12<CR>ddgg11@add:w<CR>:q<CR>
0 comments
#89 Asmund Liseth / @Asmund_L - Score: 56 - 01/14/13 @ 13:55
qw12jqggqq"aD@w"bD@w"cD@w"dDGo<C-R>a,<C-R>b,<C-R>c,<C-R>d<Esc>gg)q10@qggd)ZZ
0 comments
#90 Pasha Klets / @p01nt - Score: 57 - 02/06/12 @ 09:59
:13,23w 1<CR>:25,35w 2<CR>:37,47w 3<CR>:%!pr -mts, % 1 2 3<CR>12GdGZZ
0 comments
#91 Gavin Rogers / @KC9KVQ - Score: 58 - 03/25/13 @ 18:48
:g/^$/d<CR>:v/\a/norm I,<CR>qq:v/\a/norm d2aw11k$p<CR>q2@q12GdG:wq<CR>
0 comments
#92 Siu / @davidsinuela - Score: 61 - 02/17/12 @ 07:59
qqdd)pdj)pd2j)pd3j4(kPggq9@qdd)JP)J)JggqeJr,q@e@eqwj3@eq9@wZZ
0 comments
#93 Matt Woelk / @MattWoelk - Score: 62 - 02/08/12 @ 20:43
qq}jdd<C-O>pkJr,}}jdd<C-O><C-O>pkJr,}}}jdd<C-O><C-O><C-O>pkJr,jq10@qkdekkkf,;pa,<Esc>jdGZZ
0 comments
#94 artanis / @artanislives - Score: 63 - 02/03/12 @ 13:27
13Gdw``A,<Esc>pqaj``jdw``A,<Esc>pq9@aqb``jjdwggA,<Esc>pq10@a@b10@aj37dd:wq<NL>
0 comments
#95 Horatio Tashe / @deothrin - Score: 63 - 03/12/12 @ 03:29
:%s/$/ <CR>10kqa<C-V>10j$x12k$p0q@a@a:12,$d<CR>:%s/ *$<CR>:%s/ \+/,/g<CR>ZZ
0 comments
#96 Jonathan C. Dietrich / @jcdietrich - Score: 69 - 02/07/12 @ 17:01
qp$pqqyyawqqw$a,<Esc>qxqa@w12j@y12k@p@w24j@y24k@p@w36j@y36k@pjq10@a99ddZZ
0 comments
#97 ise0615 / @ise0615 - Score: 79 - 05/02/12 @ 11:36
qadd)pdj)p2dj)p3dj)p4Jggq9@a@@ui<Down><Down><BS><BS>,<Down><Down><Left><Left><Left><Left><BS><BS>,<Down>j<BS><Down><BS><BS>,<Esc>ggddGp:%s/ /,/g<BS>g<CR>wxi <Esc>ZZ
0 comments
#98 Bartłomiej Kozal / @bkzl_ - Score: 144 - 03/13/12 @ 15:15
qadd}pVjd}pVjjd}pJJJr,F r,F r,ddGpqgg:1,10norm! @a<CR><Esc><Esc>u@aGGgg@agg@agg@s@aggg@a<Esc><Esc>@agg@agg@agg@aGgg@agg@a<Esc><Esc>kA<Esc>ujjkkJJJJJJi<BS>,<Left><Left><Left><Left><Left><BS>,<Left><Left><Left><Left><BS>,<Esc>dd}}p:wq<CR>
0 comments
#99 Poojalakshmi / @spoojalakshmi - Score: 337 - 03/23/12 @ 08:10
<Esc>l13<Esc>f13<Esc><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Down><Left><Left> <Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Up><Right><Right><Right><Right><Right><Right><Right>i<Right>,885,1585,1710<Down>,885,1585,1710<Down>,910,1635,1760<Down>,860,1535,1535<Down>.<BS>,885,1585,1610<Down>,860,1535,1535<Down>1080<Left><Left><Left><Left>,<Right><Right><Right><Right>,1080<BS><BS><BS><BS>1885,<Up><Up><Up><Left><Del><Del><Del>660<Down><Down><Left><Del><Del><Del>660<Down>v<BS>2010<Down>.<BS>,860,1535,1660<Down>,1040,18601985<Left><Left><Left><Left>,<Down>,860,1535,1660<Down>,935,1795,1920<Down><Esc>dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd<Esc>:wq<CR>
0 comments
