Search and replace in xml file using awk..

Shell Programming and Scripting
1

Hi All,
I have xml file,i am tring to use awk to search pattern as: <Password>x</Password>

and Replace with:
<Password>y</Password>

please any one can help to solve this using awk and awk only.

2 
$ 
$ cat sample.xml
<?xml version="1.0"?>
<Member>
   <User Id=100>
      <Username>abc</Username>
      <Password>x</Password>
   </User>
   <User Id=101>
      <Username>def</Username>
      <Password>y</Password>
   </User>
   <User Id=102>
      <Username>pqr</Username>
      <Password>z</Password>
   </User>
</Member>
$ 
$ 
$ awk '{sub("<Password>x</Password>", "<Password>y</Password>"); print}' sample.xml
<?xml version="1.0"?>
<Member>
   <User Id=100>
      <Username>abc</Username>
      <Password>y</Password>
   </User>
   <User Id=101>
      <Username>def</Username>
      <Password>y</Password>
   </User>
   <User Id=102>
      <Username>pqr</Username>
      <Password>z</Password>
   </User>
</Member>
$ 
$

tyler_durden

3

the code not working proberly

more sample.xml|awk '{sub("<Password>x</Password>", "<Password>y</Password>"); print}'

awk: syntax error near line 1
awk: illegal statement near line 1

Note: i run this code on solaris

4

Try it using nawk instead of awk.

5 
sed 's/<Password>x<\/Password>/<Password>y<\/Password>/' sample.xml