how to replace field for each record

happyv · #1 (**permalink**) 06-26-2007

Hello,

I have the following xml formatted file. I would like to get the newnumber field number and replace into customernumber for each record.
For example:

<XMLFORMAT>
<customernumberR11>9</customernumberR11>
<newnumberR11>30</newnumberR11>
<customerdetailR11>

</XMLFORMT>
<XMLFORMAT>
<customernumberR11>20</customernumberR11>
<newnumberR11>18</newnumberR11>
<customerdetailR11>

</XMLFORMT>
<XMLFORMAT>
<customernumberR11>11</customernumberR11>
<newnumberR11>32</newnumberR11>
<customerdetailR11>

</XMLFORMT>

expected output:
<XMLFORMAT>
<customernumberR11>30</customernumberR11>
<newnumberR11>30</newnumberR11>
<customerdetailR11>

</XMLFORMT>
<XMLFORMAT>
<customernumberR11>18</customernumberR11>
<newnumberR11>18</newnumberR11>
<customerdetailR11>

</XMLFORMT>
<XMLFORMAT>
<customernumberR11>32</customernumberR11>
<newnumberR11>32</newnumberR11>
<customerdetailR11>

</XMLFORMT>

Many thank...and please advise.

zazzybob · #2 (**permalink**) 06-26-2007

What have you done to attempt to solve this problem yourself?

Post your sample script, and we'll see how we can assist.

Cheers,
ZB

happyv · #3 (**permalink**) 06-26-2007

i have no idea to write the script to fix...

normally, I need to do it manually...

zazzybob · #4 (**permalink**) 06-26-2007

Try something like this

Code:

#!/usr/bin/perl

open( FH, "input.txt" ) || die "Couldn't open file...\n";

while ( <FH> ) {
   $data .= $_;
}

$data=~ s/(<customernumberR11>)[0-9]*(<\/customernumberR11>\n<newnumberR11>)([0-9]*)(<\/newnumberR11>)/$1$3$2$3$4/g;

print $data;

close( FH );

exit( 0 );

Cheers
ZB

anbu23 · #5 (**permalink**) 06-26-2007

Code:

sed "/<customernumberR11>/{N;s/\(>[0-9]*<\)\(.*\)\(>[0-9]*<\)/\3\2\3/;}" filename

ghostdog74 · #6 (**permalink**) 06-26-2007

Quote:

Originally Posted by happyv

i have no idea to write the script to fix...

normally, I need to do it manually...

you have 186 posts, by now you should know how to start writing scripts or at least start something.

Code:

awk '/<customernumberR11>/{ line=$0 }
     /<newnumberR11>/{  
        current=$0
        gsub("<newnumberR11>|</newnumberR11>","",$0)
   	gsub(/>(.*)</ , ">"$0"<",line)
	print line
	print current	
	next
     }
     !/<customernumberR11>/ && !/<newnumberR11>/ {print}
' "file"

happyv · #7 (**permalink**) 06-26-2007

thank...but it look like not work

awk: syntax error near line 4
awk: illegal statement near line 4
awk: syntax error near line 5
awk: illegal statement near line 5
awk: syntax error near line 10
awk: bailing out near line 10

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
replace single field out of 60	ajp7701	Shell Programming and Scripting	2	04-21-2008 07:17 PM
Replace field in csv	pcboss	Linux	4	01-19-2008 06:24 PM
Replace password field using ed/sed	munch	UNIX for Dummies Questions & Answers	6	04-30-2007 11:01 PM
modify a few field of the record information	happyv	Shell Programming and Scripting	11	03-23-2007 01:46 PM
seaching field and getting complete record	mahabunta	UNIX for Dummies Questions & Answers	4	08-28-2006 04:52 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: