Reformat Java Sql: Difference between revisions
m (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...) |
mNo edit summary |
||
| Line 2: | Line 2: | ||
<geshi lang="bash"> | <geshi lang="bash"> | ||
sed -e 's/^[+"[:space:]]*//g; s/[[:space:]+"]*$//g' < /dev/clipboard > /tmp/$$; cp /tmp/$$ /dev/clipboard; /bin/rm /tmp/$$ | sed -e 's/^[+"[:space:]]*//g; s/[[:space:]+";]*$//g; s:" //: --:'' < /dev/clipboard > /tmp/$$; cp /tmp/$$ /dev/clipboard; /bin/rm /tmp/$$ | ||
</geshi> | </geshi> | ||
[[Category:Java]] [[Category:Sql]] [[Category:Unix]] | [[Category:Java]] [[Category:Sql]] [[Category:Unix]] | ||
Latest revision as of 02:00, 12 December 2008
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.
<geshi lang="bash"> sed -e 's/^[+"[:space:]]*//g; s/[[:space:]+";]*$//g; s:" //: --: < /dev/clipboard > /tmp/$$; cp /tmp/$$ /dev/clipboard; /bin/rm /tmp/$$ </geshi>