topic Re: awk or sed in Operating System - HP-UX

awk or sed

NS_2 — Wed, 11 Sep 2002 17:28:38 GMT

HI masters,
I have number of pro*c and .sql file which contain,
substr(a.st_no,1,3) OR substr(st_no,1,3).

I want to change it to,
substr(a.st_no,1,4) OR substr(st_no,1,4).

How can i do this using awk or sed?
Thanks in adv.
(Pts. will be given to each response.)

Re: awk or sed

Leif Halvarsson_2 — Wed, 11 Sep 2002 17:35:39 GMT

Hi
I think sed is best for this.

sed 's/substr(a.st_no,1,3)/substr(a.st_no,1,4)/' file1 >file2

Re: awk or sed

S.K. Chan — Wed, 11 Sep 2002 17:37:12 GMT

This should work (being very specific here ..)
# sed 's/st_no,1,3/st_no,1,4/g' filename > filename.new
Do a quick for loop for say all files that has ".sql" extension.
# for i in `ls *.sql`
>do
>sed 's/st_no,1,3/st_no,1,4/g' $i > $i.new
>done
#
The *.sql.new files are the ones with the replaced string.

Re: awk or sed

harry d brown jr — Wed, 11 Sep 2002 18:37:43 GMT

Nasty, but what the hell:

find PATHWHEREFILESLIVE -type f -name "*.sql" -exec grep -l -e "substr(a.st_no,1,3)" -e "subs
tr(st_no,1,3)" {} \; |
awk '{printf("sed -e \"s/substr$a.st_no,1,3$/substr$a.st_no,1,4$/\" -e \"s/s
ubstr$st_no,1,3$/substr$st_no,1,4$/\" %s > %s.dummy; mv %s.dummy %s\n", $1, $1,
$1, $1); }' |xargs -i sh {}

BUT PLEASE make SURE YOU BACKUP your files FIRST!!!!!!!!!

live free or die
harry

Re: awk or sed

Tom Maloy — Wed, 11 Sep 2002 18:53:25 GMT

Well, just in case you might consider perl...

perl -i -ne 's/st_no,1,3\)/st_no,1,4\)/g;print' yourfile

Note that this (-i option) will edit IN PLACE, overwriting your original files with the changes. To preserve your old files, save a copy, or use:

perl -i.bak -ne 's/st_no,1,3\)/st_no,1,4\)/g;print' yourfile

to keep copies with *.bak name.

Tom