Replacing a word in all lines in file based on another field value 1

[TheDash]

Hello all,
I have a file with many lines like below and several other small lines in it. For all lines that begin with CREATE DATABASE LINK I have to replace <PWD> (i.e field 10) with <field 7>_ppp . field7 is not constant and it varies from one line to other. It needs to be dynamically sustituted. Shown it below in detail, could some one help with me with the substitution?

Before:


CREATE DATABASE LINK "abc.com" CONNECT TO testuser IDENTIFIED BY <PWD> USING 'abc.com';

After replace, the line should become.

CREATE DATABASE LINK "abc.com" CONNECT TO testuser IDENTIFIED BY testuser_ppp USING 'abc.com';


Will appreciate your help. Thanks in advance.

 

[PHV]

One way:

awk '/^CREATE DATABASE LINK /{sub(/<PWD>/,$7"_ppp")}1' /path/to/input >output

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886