find command and editing

[steenb]

hi
I want to edit as a part of a find command :
find . '*.sql' -exec sed -e 's/abc/dce/' {} \;

but this just std outputs the changed lines.
is a commandfile and ed best option instead of sed
or is there an easier way to do this ?
TIA
SteenB

 

[DSMARWAY]

hi ,

you can do something like this :-

for i in `ls *.sql`
do

sed -e 's/abc/dce/' < $i >$i.$$
done

creates new file with changes in $i.$$ ( $$ pid number)

HTH

 

[steenb]

fine idea
the `ls *.sql` could also be my find or anything else for that sake.
thx
SteenB