Shell Programming and Scripting

Hi -

I am looking for a replacing a string in a in multiple *.sql files in directory with a new string without using a temporary file

Normally I can use sed command as below

for W in ls `FILE*.sql`
do
sed 's/OLD/NEW/g' $W > TEMPFILE.dat
mv TEMPFILE.dat $W
done

But Here in my scenario I do not want to make use of a temporary file ,rather I would like to directly replace the string in the original files itself.

Please suggest me any command or approach

Thanks
Raghu

try..

Code:

sed -i 's/OLD/NEW/g' FILE*.sql

Something like this :

Code:

perl -i -pe 's/OLD/NEW/ '  File_name.txt

for W in ls `FILE*.sql`
do
cat $W |sed 's/OLD/NEW/g' >$W

done

I tried the -i option but getting the below error
sed: Not a recognized flag: i

To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)

Second, avoid adding color or different fonts and font size to your posts. Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.

Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.

Thank You.

The UNIX and Linux Forums

***************************************************

Thanks to vgersh99 for that example:

Code:

printf '1,$ s/OLD/NEW/g\nw! infile\nq!'| ex - infile

Thanks Panyam.It works great.
Could you please explein me how the above command works.
I am new to perl

Thanks
Raghu

---------- Post updated at 06:51 AM ---------- Previous update was at 06:45 AM ----------

***************************************************

Thanks to vgersh99 for that example:

Code:

printf '1,$ s/OLD/NEW/g\nw! infile\nq!'| ex - infile

[/quote]

Thanks Vgersh.That works great.
Can you please explain me the above code in detail.I have never used such command to find replace a string in a file before

Regards
Raghu