Platinum Partner

Batch And Shell Script To Produce Java String From Text File

Knocked together batch / shell script to quickly convert SQL (or any text file) to a Java string (using StringBuilder). Put both the batch and the shell script into a directory on the path, add a shortcut to the batch file to your sendto folder, and then you can right click the file >> send to >> sqlify and notepad will pop up with your Java-ified text.

This requires Cygwin to be installed.

I'm sure it could be prettier, but it works.

sqlify.bat:

cat %1 | sh sqlify.sh > %1.txt
notepad "%~1.txt"


sqlify.sh:

#!/bin/sh
echo "StringBuilder sqlBuilder = new StringBuilder();"
sed -e "s/^ */sqlBuilder.append(\"/g" -e "s/$/ \");/g" | unix2dos
{{ tag }}, {{tag}},

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}
{{ parent.authors[0].realName || parent.author}}

{{ parent.authors[0].tagline || parent.tagline }}

{{ parent.views }} ViewsClicks
Tweet

{{parent.nComments}}