https://www.theeggeadventure.com/wikimedia/index.php?action=history&feed=atom&title=Reformat_Java_Sql 2026-05-13T10:33:40Z Revision history for this page on the wiki MediaWiki 1.46.0-beta https://www.theeggeadventure.com/wikimedia/index.php?title=Reformat_Java_Sql&diff=2054&oldid=prev 2008-12-12T02:00:34Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw-interface=""> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 02:00, 12 December 2008</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l2">Line 2:</td> <td colspan="2" class="diff-lineno">Line 2:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;geshi lang=&quot;bash&quot;&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;geshi lang=&quot;bash&quot;&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>sed -e 's/^[+"[:space:]]*//g; s/[[:space:]+"]*$//g' &lt; /dev/clipboard &gt; /tmp/$$; cp /tmp/$$ /dev/clipboard; /bin/rm /tmp/$$</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>sed -e 's/^[+"[:space:]]*//g; s/[[:space:]+"<ins style="font-weight: bold; text-decoration: none;">;</ins>]*$//g<ins style="font-weight: bold; text-decoration: none;">; s:" //: --:'</ins>' &lt; /dev/clipboard &gt; /tmp/$$; cp /tmp/$$ /dev/clipboard; /bin/rm /tmp/$$</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/geshi&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/geshi&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Java]] [[Category:Sql]] [[Category:Unix]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Java]] [[Category:Sql]] [[Category:Unix]]</div></td></tr> <!-- diff cache key egge_wikimedia-mw_:diff:1.41:old-2053:rev-2054:php=table --> </table>

Egge https://www.theeggeadventure.com/wikimedia/index.php?title=Reformat_Java_Sql&diff=2053&oldid=prev 2008-12-12T01:45:24Z

<p>New page: Occasionally, I come across a large multi-line SQL block inside Java code. The following sed one liner takes the code off from my clipboard, tidies it up, and puts it back in the clipboar...</p> <p><b>New page</b></p><div>Occasionally, I come across a large multi-line SQL block inside Java code. The following sed one liner takes the code off from my clipboard, tidies it up, and puts it back in the clipboard.<br /> <br /> &lt;geshi lang=&quot;bash&quot;&gt;<br /> sed -e &#039;s/^[+&quot;[:space:]]*//g; s/[[:space:]+&quot;]*$//g&#039; &lt; /dev/clipboard &gt; /tmp/$$; cp /tmp/$$ /dev/clipboard; /bin/rm /tmp/$$<br /> &lt;/geshi&gt;<br /> <br /> [[Category:Java]] [[Category:Sql]] [[Category:Unix]]</div>

Egge