VimGolfCSV to JSON
A search for shortest vimissh way to convert CSV to JSON.
Start file
Year,Make,Model,Length 1997,Ford,E350,2.34 2000,Mercury,Cougar,2.38
End file
[
{
"Year": "1997",
"Make": "Ford",
"Model": "E350",
"Length": "2.34"
},
{
"Year": "2000",
"Make": "Mercury",
"Model": "Cougar",
"Length": "2.38"
}
]
View Diff
1,3c1,14
< Year,Make,Model,Length
< 1997,Ford,E350,2.34
< 2000,Mercury,Cougar,2.38
---
> [
> {
> "Year": "1997",
> "Make": "Ford",
> "Model": "E350",
> "Length": "2.34"
> },
> {
> "Year": "2000",
> "Make": "Mercury",
> "Model": "Cougar",
> "Length": "2.38"
> }
> ]
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 40 remaining solutions by signing in and submitting your own entry
#41 Franco Lazzarino / @flazz - Score: 157 - 01/04/11 @ 12:19
:%s/,/<C-V><CR>/g<CR>:%norm I"<CR>:%norm A"<CR>:1,4norm A: <CR>:5,7norm A,<CR>:<Up><Left><Left><Left><Left><Left><Left><Left><BS><BS><BS>9,11<CR>:<Esc><Esc>gg<C-V>jjj$x5ggP9ggP:s<BS>%s/:\s*/: /<CR>8ggo},<CR>{<Esc>Go}<CR>]<Esc>5ggO{<Esc>O[<Esc>kdgg:2,13><CR>:3,6><CR>:9,12><CR>ZZ
0 comments
#42 Christopher Brew / @Seph1rothVII - Score: 158 - 01/13/12 @ 10:51
i[<CR><Esc>Yjpjo]<Esc>:%s/\v^(\a+),(\a+),(\a+),(\a+)\n(\d+),(\a+),([^,]+),(w\<BS><BS>.+)$/\t{\r\t\t"\1": "\5",\r\t\t"\2": "\6",\r\t\t"\3": "\7",\r\t\t"\4": "\8"\r\t}/g<CR>7Ga,<Esc>ZZ
0 comments
#43 drio / @drio - Score: 161 - 01/16/11 @ 07:48
:%s/,/<C-V><CR>/g<CR><C-V>ggI"<Esc>qqA": <Esc>0jq3@qqqA",<Esc>0jq7@q$D:8<CR>$Dgg"ayWj"byWj"cyWj"dyWj"aPj0"bPj0"cPj0"dPj0"aPj0"bPj0"cPj0"dPgg4ddO[<CR><Tab>{<Esc>j0v3j$>.:7<CR>O<Tab>},<CR>{<Esc>j0v3j$>.:12<CR>o<BS>}<CR>\<BS><BS>]<Esc>ZZ
0 comments
#44 Lajos Koszti / @Ajnasz - Score: 166 - 01/06/11 @ 05:48
yyjpggqa:s/,/: /g<CR>df jPk^df jf,pk^df j2f,pk^Dj3f,pa: <Esc><Esc>^C{<CR><0xe2><0x87><0xa7>}<Esc>kkjo<Esc>pj^xk:s/,/,\r/g<CR>qjj@a:%s/\([a-z0-90<BS>.]\+\)/|\<BS><BS>:<BS>"\1"/g<CR>ggi[<Esc>Go]<Esc>kVjh%j>jVk%k>jj/{<CR>j.kkddka,<Esc><Esc>:x<CR>
0 comments
#45 Adrian Silva / @scyldinga - Score: 176 - 01/10/12 @ 02:29
i[<CR><Tab>{<CR><Tab>"<Esc>wwi": "1997"<Esc>lli<CR>"<Esc>ww"i:<Esc><Esc>i": "Ford",<Esc>lxi<CR>"<Esc>wwi": "E35[<BS>0"<Esc>lli<CR>"<Esc>wwb$a": "3<BS>2.34"<CR>}<Esc><<o}<BS>]<Esc><<<Esc>:2,7y<CR>kpka,<Esc>jjf1ct"2000<Esc>jxcTF<Esc>xiMecr<BS><BS>rcury<Esc>jhcT"Cougar<Esc>jcT"2.38<Esc>3j2dd:x<CR>
0 comments
#46 Karl Eklund / @keklund - Score: 191 - 01/03/11 @ 18:47
yyjpkkqqdwjPa,<Esc>t,lr<CR>kddpkkxq@q@qJr,0jjjj@q@q@qJr,0<C-A>0VG!tac<CR>kVkkk!tac<CR>O[<CR><Tab>{<Down><Down><Down><Down><CR><BS><Right><Right><Right><CR><Tab>},<CR>{<Down><Down><Down><Down><Down><Right><Right><CR><Tab>}<CR><BS>]<Esc>ggjj:%s/(.*),(.*)/"\1<BS><BS><BS>\t\t"\1": "\2",/<CR>qqi<Tab><Tab>"<fd-56>": <Del>"<End>",<Esc>0j0q@q@q@q<Up><End>x<Down><Down><Down>04@q<Up><End>x<Left><Left><Left><Left>r2ZZ
0 comments
#47 Christopher Sexton / @fuzzymonk - Score: 204 - 01/01/11 @ 12:08
:<Up>%s/\(\w\+\)/"\1"/g<CR>qq0f.dhlxq:2<CR>@qk0df,jPr:a <Esc>j0.uhPr: i <Esc>ggdf,jf,a<CR>P<BS><Esc>Pr:<Esc>jf,a<CR><Esc>Pr: i <Esc>ggdf,2j2f,F,a<CR><Esc>Pr:a <Esc>jjf,a<CR><Esc>Pr:a <Esc>ggDi[<CR><Tab>{<Esc>:5<CR>f,a<CR><Esc>Pa: <Esc>o},<CR>{<Esc>:11<CR>f,a<CR><Esc>Pa: <Esc>o}<CR>]<Esc>Vgg=j<C-V>jI<Tab><Esc>:7<CR><C-V>jjjjjjI<Tab><Esc>:4<CR>f:a <Esc>ZZ
0 comments
#48 Ilya Ermolin / @ermolinis - Score: 210 - 01/01/11 @ 11:25
:let l = map(getline(1,3),'split(v:val,",")')<CR>:for i in range(4)<CR>let t = 1<CR>let l[t][i] = "\t\t\"".l[o]<BS><BS>0][i].'": '<BS>"'.l[t][i].'",'<CR><Up><Up><BS>2<CR><Up><Up><CR>endfor<CR>3dd:s/^/\=l[1]+l[2]<CR>gg0i<CR><Up>i<BS>[<CR><Tab>{<CR><Del><Tab><Down><Down><Down><Down><Up><End><Left><CR><BS>}<Right><CR>{<Down><Down><Down><Down><End><BS><CR><BS>}<CR><BS>]<Esc>ZZ
0 comments
#49 Dan Williams / @deft_of_center - Score: 272 - 04/02/13 @ 21:02
:%s/^\|$/"/g<CR>:%s/,/",#"/g<CR>:s$<BS>/$/\r\t}\r]/<CR>:s,1<BS><BS><BS>,1s/^/[\r\t{\r/<CR>n<CR><Up><Up><Up><Up>:s/^/[\r\t{\r/<CR>:s/,/: /g<CR>A:<Esc>:%s/#/\r<CR>:<Up>/g<CR>qauuY<Down>p:%s/#/\r/g<CR>qadd<BS><BS><Esc>dd3kPkJjjjqa^DDdduuqqadd3j3k3kqjjjudd3kOuu<BS><BS><BS><Esc>uuuuuqadd3kPkJ3jq3@a4k4@a:s/&<BS>$/\r\t}.\<BS><BS>,\r{\r/<CR><Left><Down><Up><Up><Tab><Down><Up>i<Tab><Down><BS>:%s^<BS><BS><BS><BS><Esc>:s<BS>%s/^"/\t\t"/<CR>ZZ
0 comments
#50 ise0615 / @ise0615 - Score: 395 - 05/13/12 @ 00:35
i"<Esc>wwi"<Right><CR>"<Esc>ww.ui"<Right><CR><Esc>.ui"<Esc>wwi"<Right><CR><Esc>.ui"<Esc>wwkwwblllllla"<CR><Esc>jkkkkkkkk$a<BS>:<Down><BS>:<Down><Right><BS>:<Down><Right>:<Esc>jkkkkkk0i[<CR>{<CR><Esc>jjjji},<CR><Esc>kkkkkkvjjjjjlljkhhyjjjjjpi,<CR><Esc>jjjjjlxji]<Esc>jv$dkkkkkkkkkkkk$pi <Esc>wwlv$djla <Esc>plllllv$djla <Esc>pllllv<Esc>lDjja<Esc>phhhi <Esc>kddjjjjjjjjjjjddkkkkk$pi<BS> <Esc>llllllDjla <Esc>pbbbbbv$duv$hdjla <Esc>pbhbv$duv$hdjla <Esc>pa"<Esc>hhhh.ub.u<Left><Left>.<Up><Left><Left>.<Up><Left><Left>.<Up><Left>.<Right><Right><Right><Right>.<Down><Right><Right>.<Down><Left>.<Up><Up><Up><Up><Up>.<Up><Left>.<Up><Left>.<Up><Left>.<Left><Left><Left><Left><Left>.<Down><Left>.<Down><Left><Right>.<Down><Right><Left>.<Esc>0kkkk<C-V>jjjjj>jl<C-V>jjjjk>jjjjj<C-V>jjjjj>jl<C-V>jjj>ZZ
0 comments
