$ cat input.sql
SELECT ID, NAME
FROM USERS
WHERE ID = :USERID
$ cat replace.sh
file1=input.sql
file2=$file1.bak
cp $file1 $file2
echo $file2
perl -pi -e "s/:/#{/g;" $file2
perl -pi -e "s/#\{\w*\b\K/}/g;" $file2
#sed -i 's/^/ /g' $file2
cp $file2 out
$cat out
SELECT ID, NAME
FROM USERS
WHERE ID = #{USERID}
