[SOLVED] Replace a string in nextline after searching a pattern Post: 302701079

Sponsored Content

Top Forums Shell Programming and Scripting [SOLVED] Replace a string in nextline after searching a pattern Post 302701079 by mailing2vamsi on Friday 14th of September 2012 04:18:20 PM

09-14-2012

Registered User

Thanks for all your suggestions, but I am failing to full fill the requirements.

XML data is in a file and modified data should be updated to same file. only data having ">#!...<" needs to be changed if Element1, Element2 and user are available previous line. please find the original and output below:

Can some please help me to break this, thanks in advance.

Original:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<application>
<repoInstanceName>%%DOMAIN%%-PrintFileProcessorBW</repoInstanceName>
<NVPairs>
<NameValuePairPassword>
<name>Message/Element1/MIG</name>
<value>#!YEkZA=</value>
</NameValuePairPassword>
<NameValuePairPassword>
<name>Message/Element2/MIG</name>
<value>#!FQKi0=</value>
</NameValuePairPassword>
<NameValuePairPassword>
<name>Message/Element3/MIG</name>
<value>#!FQKi0=</value>
</NameValuePairPassword>
<NameValuePairPassword>
<name>Message/Element1/MIG</name>
<value>#!Lo44o=</value>
</NameValuePairPassword>
<NameValuePairPassword>
<name>Message/Element2/MIG</name>
<value>#!HkCM=</value>
</NameValuePairPassword>
<NameValuePairPassword>
<name>Message/Element3/MIG</name>
<value>#!FQKi0=</value>
</NameValuePairPassword>
</NVPairs>
<repoInstances selected="local">
<httpRepoInstance>
<user>ABC</user>
<password>#!JQLYU</password>
</httpRepoInstance>
<rvRepoInstance>
<user>ABC</user>
<password>#!WiRN4</password>
</rvRepoInstance>
</repoInstances>
</application>

Modified:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<application>
<repoInstanceName>%%DOMAIN%%-PrintFileProcessorBW</repoInstanceName>
<NVPairs>
<NameValuePairPassword>
<name>Message/Element1/MIG</name>
<value>#!AAAAA</value>
</NameValuePairPassword>
<NameValuePairPassword>
<name>Message/Element2/MIG</name>
<value>#!AAAAA</value>
</NameValuePairPassword>
<NameValuePairPassword>
<name>Message/Element3/MIG</name>
<value>#!FQKi0=</value>
</NameValuePairPassword>
<NameValuePairPassword>
<name>Message/Element1/MIG</name>
<value>#!AAAAA</value>
</NameValuePairPassword>
<NameValuePairPassword>
<name>Message/Element2/MIG</name>
<value>#!AAAAA</value>
</NameValuePairPassword>
<NameValuePairPassword>
<name>Message/Element3/MIG</name>
<value>#!FQKi0=</value>
</NameValuePairPassword>
</NVPairs>
<repoInstances selected="local">
<httpRepoInstance>
<user>ABC</user>
<password>#!AAAAA</password>
</httpRepoInstance>
<rvRepoInstance>
<user>ABC</user>
<password>#!AAAAA</password>
</rvRepoInstance>
</repoInstances>
</application>

mailing2vamsi

View Public Profile for mailing2vamsi

Find all posts by mailing2vamsi

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Searching for files with certain string pattern

Hello All I would like to search for files containing certain string pattern under all the directories under /vobs/vobname and print the output to a file in my home directory. How can I do this? Note: /vobs/vobname conatins several directories. Thank You in advance newbetounix

2. Shell Programming and Scripting

Match pattern and replace with string

hi guys, insert into /*<new>*/abc_db.tbl_name this is should be replaced to insert into /*<new>*/${new}.tbl_name it should use '.' as delimiter and replace is there any way to do it using sed

3. Shell Programming and Scripting

Pattern searching and replace

I have data this data in a text file 1 PSE480 (P) 2 PSE600 (P) 3 (P) PSE600 4 (P) PSE720 5 PSE600 (P) 6 PSE720 (P) 7 x12(P)PSE360 8 PSE450 (P) 9 PSE540 (P) 10 PSE720 (P) 11 (P) PSE1440 12 24sPSE720 (P) What i want id the last 3 (or 4 in one case) characters after PSE my final...

4. Shell Programming and Scripting

Searching String from set of similar File pattern from the Dir

Guys, Here is the script that searches string from the set of similar files from the log directory, All the file patterns are defined as input file, from where the script should map to those files in the LOG_DIR and should start searching the strings from all those similar files. ...

5. Shell Programming and Scripting

sed or awk command to replace a string pattern with another string based on position of this string

here is what i want to achieve... consider a file contains below contents. the file size is large about 60mb cat dump.sql INSERT INTO `table1` (`id`, `action`, `date`, `descrip`, `lastModified`) VALUES (1,'Change','2011-05-05 00:00:00','Account Updated','2012-02-10...

6. Shell Programming and Scripting

Searching a particular string pattern in 10000 files

Problem Statement:- I need to search a particular `String Pattern` in around `10000 files` and find the records which contains that `particular pattern`. I can use `grep` here, but it is taking lots of time. Below is the command I am using to search a `particular string pattern` after...

7. Shell Programming and Scripting

Replace a string pattern

Hi, I have a CSV with following type of data and would like to replace the timestamp information with 'null' string. Can you please suggest me on same? 8,1,'1','1',11,'2013-08-12 18:34:17.0','null',1,'2013-08-12 18:34:17.0','null','PROMOTIONAL','12','1','11','11',11,'0' Thanks for your...

8. Shell Programming and Scripting

Replace string in line below specific pattern?

Hi, I'm trying to replace a string with sed, in a text file containing this pattern: location alpha value x location beta value y location gamma value y location delta value y location theta value z ... What I want to achieve is: Find location beta into text file...

9. UNIX for Dummies Questions & Answers

[Solved] Replace the second pattern alone in VI.

I have lines like: table10 table_name_10 table10 table_name_10 table20 table_name_20 table20 table_name_20 table30 table_name_30 table30 table_name_30 I want to change the second "table_names" in all lines to test_table_name. Required output would be: table10 table_name_10 table10...

10. Shell Programming and Scripting

Replace string - searching from input file

Hi I need help with writing a script to change a string in a file. The script needs to read an input list (list.txt) file line by line searching for that string in a text.file. Once the string is found the last few words in the string should be replaced. eg list.txt will contain hello my...

LEARN ABOUT REDHAT

xml::dumper

Dumper(3)						User Contributed Perl Documentation						 Dumper(3)

NAME

       XML::Dumper - Perl module for dumping Perl objects from/to XML

SYNOPSIS

	# Convert Perl code to XML
	use XML::Dumper;
	my $dump = new XML::Dumper;
	$data = [
		 {
		   first => 'Jonathan',
		   last => 'Eisenzopf',
		   email => 'eisen@pobox.com'
		 },
		 {
		   first => 'Larry',
		   last => 'Wall',
		   email => 'larry@wall.org'
		 }
		];
	$xml =	$dump->pl2xml($perl);

	# Convert XML to Perl code
	use XML::Dumper;
	my $dump = new XML::Dumper;

	# some XML
	my $xml = <<XML;
       <perldata>
	<scalar>foo</scalar>
       </perldata>
       XML

	# load Perl data structure from dumped XML
	$data = $dump->xml2pl($Tree);

DESCRIPTION

       XML::Dumper dumps Perl data to a structured XML format.	XML::Dumper can also read XML data that was previously dumped by the module and
       convert it back to Perl.

       This is done via the following 2 methods: XML::Dumper::pl2xml XML::Dumper::xml2pl

AUTHOR

       Jonathan Eisenzopf <eisen@pobox.com>

CREDITS

       Chris Thorman <ct@ignitiondesign.com> L.M.Orchard <deus_x@pobox.com> DeWitt Clinton <dewitt@eziba.com>

SEE ALSO

       perl(1), XML::Parser(3).

perl v5.8.0							    1999-06-20								 Dumper(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Searching for files with certain string pattern

Discussion started by: intrigue

2. Shell Programming and Scripting

Match pattern and replace with string

Discussion started by: sol_nov

3. Shell Programming and Scripting

Pattern searching and replace

Discussion started by: lifzgud

4. Shell Programming and Scripting

Searching String from set of similar File pattern from the Dir

Discussion started by: raghunsi