VimGolfCleanining up 80 column concatenated text
1. Put the whole query on one line, remove the concatenation operators 2. Remove the double spaces that appear a few times in the query 3. Use string-interpolated variable statementPid rather than the ugly concatenation
Start file
$atres = sqlStatement("select f.name,f.street,f.city,f.state,f.postal_code from facility f " .
" left join users u on f.id=u.facility_id " .
" left join billing b on b.provider_id=u.id and b.pid = '".$stmt['pid']."' " .
" where service_location=1");
$row = sqlFetchArray($atres);
End file
$atres = sqlStatement("select f.name,f.street,f.city,f.state,f.postal_code from facility f left join users u on f.id=u.facility_id left join billing b on b.provider_id=u.id and b.pid = $statementPid where service_location=1");
$row = sqlFetchArray($atres);
View Diff
1,4c1
< $atres = sqlStatement("select f.name,f.street,f.city,f.state,f.postal_code from facility f " .
< " left join users u on f.id=u.facility_id " .
< " left join billing b on b.provider_id=u.id and b.pid = '".$stmt['pid']."' " .
< " where service_location=1");
---
> $atres = sqlStatement("select f.name,f.street,f.city,f.state,f.postal_code from facility f left join users u on f.id=u.facility_id left join billing b on b.provider_id=u.id and b.pid = $statementPid where service_location=1");
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.
#47 Sebastian Korten / @FlashKorten - Score: 49 - 07/20/12 @ 08:42
4J:s!"[ .]*"!!g<CR>:s! *! !g<CR>f'c3f'$statementPid<Esc>ZZ
0 comments
#48 Stephen Crosby / @stevecrozz - Score: 53 - 07/18/12 @ 22:20
j<C-V>tljjxj3f xjF xkf'c3f'$statementPid<Esc>qq$xxxxkq2@q4JZZ
0 comments
#49 Reed Riley / @ReedRile - Score: 54 - 08/11/12 @ 10:55
4J:s/" . "//g<CR>:s/ / /g<CR>/stmt<CR>da"ca'$statementPid <Esc>ZZ
0 comments
#50 Adelar S. Queiróz / @adelarsq - Score: 54 - 12/04/12 @ 15:21
4J:%s/\( " . " \)\|\( \)/ /g<CR>f'i$statementPid<Esc><Right>18xZZ
0 comments
#51 Mateusz Zawisza / @mateuszzawisza - Score: 55 - 06/23/12 @ 15:20
f"qqf"DJdwq@q2f"@q:%s/\ \ /\ /g<CR>f'3df'i$statementPid<Esc>ZZ
0 comments
#52 J Paul Daigle / @jpauldaigle - Score: 55 - 06/25/12 @ 10:01
j<C-V>tljjx:%s/" .\n//g<CR>:s/\ \ /\ /g<CR>f'ctw$statementPid <Esc>ZZ
0 comments
#53 Juanje Ojeda / @juanjeojeda - Score: 58 - 07/04/12 @ 19:30
:<Up>%s/\" .\n \" //g<CR>:s/ / /g<CR>:s/'.*'/$statementPid/<CR>:<Esc><Esc>ZZ
0 comments
#54 Christopher Garvis / @cgarvis - Score: 60 - 09/10/12 @ 08:47
4J:s!"[ .]*"!!g<CR>:s !!<BS> <BS> *! !g<CR>f'c3f;c3f'$statementPid<Esc>:wq<CR>
0 comments
#55 Pandae / @psasqw - Score: 61 - 06/26/12 @ 05:57
j<C-V>2Wh2jxfd;lDjFb;;hxf=;ll3xlllCatementPid<Esc>4Gf x:1,4j<CR>f";dtlZZ
0 comments
#56 Ryan O'Connell / @Salshammath - Score: 65 - 06/23/12 @ 14:18
4J:%s/'".*"'/$statementPid/|%s/ \@=//g|%s/"\s\+\.\s\+"\s*//g<CR>ZZZ
0 comments
#57 Sven Koesling / @McSvenster - Score: 80 - 08/14/12 @ 08:03
:%s/" \.\n " // | s/'"\.\$stmt\['pid'\]\."'/\$statementPid/ | s/ \+/ /<CR>u:<Up>g<CR>ZZ
0 comments
#58 Alberto Alcaraz / @Subastkar - Score: 88 - 06/25/12 @ 14:21
:%s/" \.\n "<CR>:%s'<BS>/ ' <BS><BS>/ <BS>/g<CR>:%s/'".$\<stmt\>\['\<pid\>'\]."'/$statementPid/g<CR>:q<BS>wq<CR>
0 comments
