DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Batch And Shell Script To Produce Java String From Text File

  • submit to reddit
        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.

cat %1 | sh > %1.txt
notepad "%~1.txt"
echo "StringBuilder sqlBuilder = new StringBuilder();"
sed -e "s/^ */sqlBuilder.append(\"/g" -e "s/$/ \");/g" | unix2dos