How to replace a string if another specific string exists in the line

victorcheung · 06-26-2015, 10:20 AM

Hi,

A file contains sample data as below:

:
ini.parameter1('_DB_NAME_','PROD');
ini.parameter2('_DB_NAME_','UAT');
ini.parameter3('_DB_NAME_','DEV');
ini.parameter4('_DB_NAME_','STG');
:

and I want to write a bash script to replace the value after the '_DB_NAME_' as 'TEST', so, the new file will become:

:
ini.parameter1('_DB_NAME_','TEST');
ini.parameter2('_DB_NAME_','TEST');
ini.parameter3('_DB_NAME_','TEST');
ini.parameter4('_DB_NAME_','TEST');
:

how to do this?

Thanks!
Victor

firstfire · 06-26-2015, 10:48 AM

Hi.

Code:

$ sed "/_DB_NAME_/s/,'[^']*'/,'TEST'/" infile
:
ini.parameter1('_DB_NAME_','TEST');
ini.parameter2('_DB_NAME_','TEST');
ini.parameter3('_DB_NAME_','TEST');
ini.parameter4('_DB_NAME_','TEST');
:

TB0ne · 06-26-2015, 01:47 PM

Quote:

Originally Posted by victorcheung

Hi,
A file contains sample data as below:

ini.parameter1('_DB_NAME_','PROD');
ini.parameter2('_DB_NAME_','UAT');
ini.parameter3('_DB_NAME_','DEV');
ini.parameter4('_DB_NAME_','STG');

and I want to write a bash script to replace the value after the '_DB_NAME_' as 'TEST', so, the new file will become:

ini.parameter1('_DB_NAME_','TEST');
ini.parameter2('_DB_NAME_','TEST');
ini.parameter3('_DB_NAME_','TEST');
ini.parameter4('_DB_NAME_','TEST');

how to do this?

firstfire gave you a solution. However, you need read the LQ Rules and "Question Guidelines" link in my posting signature. You need to show some effort of your OWN, rather than asking people to just hand you an answer. Also, the way this question is written and your user name point to this not being your first post on LQ....

victorcheung · 06-26-2015, 07:20 PM

Quote:

Originally Posted by firstfire

Hi.

Code:

$ sed "/_DB_NAME_/s/,'[^']*'/,'TEST'/" infile
:
ini.parameter1('_DB_NAME_','TEST');
ini.parameter2('_DB_NAME_','TEST');
ini.parameter3('_DB_NAME_','TEST');
ini.parameter4('_DB_NAME_','TEST');
:

Hi firstfire,

Thank you very much, it works!

Victor