Shell Programming and Scripting

Hi

I have a cross reference file which contains 86000 records. The data is old number:new number. There are 100s of files where i need to search for old number and append corresponding new number (preceded by @) to the line containing old number. The files contain millions of records.
Currently I am using sed command as below:

Code:

  sed "/$v_s_replace_string/s/$/$v_s_new_string/" $v_s_file_name > tempfile1
  mv tempfile1 $v_s_file_name

v_s_replace_string = contains old number
and v_s_new_string = contains new number

I need to replace this sed command with and awk command as awk is faster than sed.

Please help.
Thanks

its similar.. I don't think it will make any huge diff..

Code:

awk -v old=$v_s_new_string  -v old=$v_s_replace_string  '{gsub(old,new)}1' $v_s_file_name > tempfile1
mv tempfile1 $v_s_file_name

Hi
Thanks for your solution.

I am trying that.
Is there any other option that you can suggest. I need to speed up the processing as much as possible. It is a production run and my script should not take more than 5 mins per file.

Thanks

Did you try command line perl or a perl script .

Hi

For the awk command... could you please modify it to append the new number at the end of the line where it finds a match with old number. The command you gave is adding the new number to begining of the line. I am new to awk. Please help.

you mean this??

Code:

awk -v var=$v_s_replace_string  '{if($0 ~ '/$v_s_new_string'/}{print $0":"var}else{print}}' $v_s_file_name > tempfile1
mv tempfile1 $v_s_file_name

Hi
Thanks for your help and time. But the code you sent is not helping.
It is appending all the new number strings to one record only.

I need to appedn the new number only to that record where it matches the corresponding old number.

I tried this:

Code:

awk -v var=$v_s_new_string  /$v_s_replace_string'/{print $0""var}' $v_s_file_name > tempfile1
mv tempfile1 $v_s_file_name

Please help.