Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Place semi-colon at the end of the last line
- Thread starter Tdlearner
- Start date
How are you using the *.sql files?
Mike
When working on any project the value of other people is exactly that - they are other people, with views that don't necessarily match yours. This mismatch, between their views and the view you've been contentedly assuming is right, is where that value lies.
Mike
When working on any project the value of other people is exactly that - they are other people, with views that don't necessarily match yours. This mismatch, between their views and the view you've been contentedly assuming is right, is where that value lies.
- Thread starter
- #3
I have bunch of sql files , all have select statements but
semicolon missing at the end of the last lines.
I have written the following sed script to add a semi colon at the end .
file=$1
sed '$d' $file > ${file}.new
sed -n '$p' $file | sed 's/$/ ;/g' >> ${file}.new
mv ${file}.new $file
I was just wondering perl should have more elegant solution.
thanks,
semicolon missing at the end of the last lines.
I have written the following sed script to add a semi colon at the end .
file=$1
sed '$d' $file > ${file}.new
sed -n '$p' $file | sed 's/$/ ;/g' >> ${file}.new
mv ${file}.new $file
I was just wondering perl should have more elegant solution.
thanks,
- Status
Similar threads
