Shell Programming and Scripting

Hi,

We have a file (e.g. a .csv file, but could be any other format), with 2 columns: the old value and the new value. We need to modify all the files within the current directory (including subdirectories), so find and replace the contents found in the first column within the file, with the contents of the 2nd column

e.g. the file can contain:

COL1 -- COL2
old_one new_one

So for all .sql files, i want to replace the string 'old_one' with 'new_one'.
Is it possible this? If so, how?

Thanks!

Try this...

Code:

ls -l *.csv | awk '{print $9}' > csvfiles.txt
cat csvfiles.txt  | while read LINE
do
   sed 's/oldstring/newstring/g' $LINE > $LINE.txt
   mv $LINE.txt $LINE
done

But what's that $LINE.TXT? I did not want to create another file, but in the original file to replace what's in the first column, with the content of the second one
I have only one csv, so what this does?
ls -l *.csv
My csv file is examples.csv

---------- Post updated at 11:46 PM ---------- Previous update was at 02:17 PM ----------

any help, please? regarding to previous post

---------- Post updated 12-07-12 at 07:46 AM ---------- Previous update was 11-07-12 at 11:46 PM ----------

Also, who is oldstring / newstring?

What does ur examples.csv contain?

You just want to replace "old_one" with "new_one" in that csv file alone or all of the sql files?

oldstring/newstring means oldstring could be anything that you want to replace. And newstring is the string that you want the older one to be replaced with

My csv looks like in attachament. I want to replace what i found in the first column with the second one.. that's why i asked how should be specified this in that script, the content of the first column, and the one of the second one.

So, you want to replace

Code:

raise_application_error(-20100, 'An error!'); => new_string1
raise_application_error(-20100, 'Another error!'); => new_string2

right?

Exactly, in all .sql files within the current directory (and subdirectories), where i find
raise_application_error(-20100, 'An error!');it should be replaced with new_string1,

similar with the second line , and so on... i can have many lines in that file.
Thanks!

---------- Post updated at 02:03 PM ---------- Previous update was at 09:00 AM ----------

any help, please?