Shell Programming and Scripting

Hi,

I tried this but could not get it...
here is what I need I have an xml where I get all the data in blocks but some times I get empty blocks with no data...shown below..I need to delete only those blocks with no data, I tried couple of ways but could not do it..any help is appreciated...

<CeValueCSVExt2>
<CeValueValueID>COI_RATE</CeValueValueID>
<CeValueDuration>1</CeValueDuration>
<CeValueCharValue>ART </CeValueCharValue>
<CeValueAllowUpdateInd tc="1">True</CeValueAllowUpdateInd>
</CeValueCSVExt2>

<CeValueCSVExt3>
<CeValueAllowUpdateInd tc="1">True</CeValueAllowUpdateInd>
</CeValueCSVExt3>

<CeValueCSVExt17>
</CeValueCSVExt17>
The last block need to be deteted is there any command I can do it as part of script to delete those blocks like "<CeValueCSVExt17></CeValueCSVExt17>"

Thanks,
Girinath.

Try perl....

Code:

#!/usr/bin/perl

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

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

$data =~ s!<CeValueCSVExt[0-9]+>\n</CeValueCSVExt[0-9]+>\n!!g;

print $data;

close( FH );

Then...

Code:

/path/to/girin.pl > girin.new.xml && mv girin.new.xml girin.xml

Cheers
ZB