Batch And Shell Script To Produce Java String From Text File

• Tweet
• 

        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

Tags:
• batch
• convert
• cygwin
• java
• shell
• SQL
• String
• stringbuilder