grep a string in the lines between 2 strings of a file

bhagirathi · #1 (**permalink**) 07-10-2009

Hi ,
Please help me with the following problem:
I have an xml file with the following lines

Code:

<cisco:name>
  <cisco:mdNm>Cisco Device 7500 A Series</cisco:mdNm>
  <cisco:meNm>10.1.100.19</cisco:meNm>
  <cisco:ehNm>/shelf=1</cisco:ehNm>
      <cisco:subname>
         <cisco:sptp>Cisco PortA Series</cisco:sptp>
         <cisco:aliasNameList xsi:nil="true"/>
         <cisco:owner xsi:nil="true"/>
                      <cisco:subportname>
                 <cisco:cpt>Cisco SubPort B Series</cisco:cpt>
                 <cisco:aliasNamesubList xsi:nil="true"/>
                 <cisco:userLabel xsi:nil="true"/>
               </cisco:subportname>
       </cisco:subname>
           <cisco:subname>
         <cisco:sptp>Cisco PortAB Series</cisco:sptp>
         <cisco:aliasNameList xsi:nil="true"/>
         <cisco:owner xsi:nil="true"/>
                      <cisco:subportname>
                 <cisco:cpt>Cisco SubPort AB Series</cisco:cpt>
                 <cisco:aliasNamesubList xsi:nil="true"/>
                 <cisco:userLabel xsi:nil="true"/>
               </cisco:subportname>
       </cisco:subname>
</cisco:name>
<cisco:name>
  <cisco:mdNm>Cisco Device 7500B Series</cisco:mdNm>
  <cisco:meNm>10.1.100.20</cisco:meNm>
  <cisco:ehNm>/shelf=2</cisco:ehNm>
      <cisco:subname>
         <cisco:sptp>Cisco Port B Series</cisco:sptp>
         <cisco:aliasNameList xsi:nil="true"/>
         <cisco:owner xsi:nil="true"/>
                      <cisco:subportname>
                 <cisco:cpt>Cisco SubPort B Series</cisco:cpt>
                 <cisco:aliasNamesubList xsi:nil="true"/>
                 <cisco:userLabel xsi:nil="true"/>
               </cisco:subportname>
       </cisco:subname>
</cisco:name>

In My code it will first check the two strings <cisco:name> and </cisco:name> and after that it will grep the count of <cisco:cpt>. and so on continue till the end of file

Code:

#!/bin/sh
sed '/<\/cisco:name>/{G;}' test.xml >temp 

nawk 'BEGIN{RS=""} 
{ 
grep -c '<cisco:cpt>' print 


}' temp 
rm temp

this code is not giving the the op as
in first<cisco:name> and </cisco:name> loop it should give 2 then for next it would 1

plz help

honglus · #2 (**permalink**) 07-10-2009

Code:

awk '{ if (  $0 ~ /<cisco:cpt>/  )  {i++} if ( $0 ~ /<\/cisco:name>/ ) {print i;i=0}}' test.xml

bhagirathi · #3 (**permalink**) 07-10-2009

Hi Honglus,
thanks it works fine. but i have one query
if i have to search two or 3 patterns like <cisco:cpt> , <cisco:mdNm> ,<cisco:sptp> then how can i proceed.

honglus · #4 (**permalink**) 07-10-2009

Quote:

Originally Posted by bhagirathi

Hi Honglus,
thanks it works fine. but i have one query
if i have to search two or 3 patterns like <cisco:cpt> , <cisco:mdNm> ,<cisco:sptp> then how can i proceed.

link them with OR, something like this:
$0 ~ /(one|two|three)/

summer_cherry · #5 (**permalink**) 07-10-2009

more formally, perl can handle XML document with many availiable module.

You may try below to see the result

Code:

use XML::Parser;
my $file = 'a.xml';
my ($flag,$index,@arr,%hash)=(0,-1);
sub start_handler
{
    my $expat = shift; 
    my $element = shift;
    if($element eq 'cisco:name'){
			$index++;
		}
		else{
			if($element eq 'cisco:cpt'){
				$flag=1
			}
			else{
				$flag=0;				
			}
		}
}
sub char_handler
{
    my ($p, $data) = @_;
    if( ($flag eq '1') and  !($data =~ /^\s*$/)){
    	$arr[$index]++;
    	$hash{$index}.="  ".$data;
    }
}
my $parser = new XML::Parser(ErrorContext => 2);
$parser->setHandlers(Start => \&start_handler,
                     Char  => \&char_handler);
$parser->parsefile($file);
for(my $i=0;$i<=$#arr;$i++){
	print $arr[$i],"\n";
	print $hash{$i},"\n";
	print "--------\n";
}

bhagirathi · #6 (**permalink**) 07-10-2009

i did the same

Code:

awk '{ if (  $0 ~ /<cisco:cpt> | <cisco:sptp>/  )  {i++} if ( $0 ~ /<\/cisco:name>/ ) {print  "cpt=" i;i=0}}' test.xml

But the result added . so could you suggest how can it will print that differently
like
cpt= 1
sptp=2

ghostdog74 · #7 (**permalink**) 07-10-2009

gawk

Code:

awk 'BEGIN{ RS="</cisco:name>"}
{
  m=split($0,a,"\n")
  f=0
  for(i=1;i<=m;i++) {
    if(a[i] ~ /<cisco:cpt>/){
        f++    
    }
  }
  print f
}' file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to get lines started with matched strings using sed or grep for loop?	AMBER	Shell Programming and Scripting	8	07-13-2009 05:26 AM
Grep and delete lines except the lines with strings	vj8436	Shell Programming and Scripting	14	04-17-2009 11:25 AM
To grep 10 lines after a string in a txt file.	suman82	Shell Programming and Scripting	6	12-13-2008 01:08 AM
grep string & a few lines after	ashterix	Shell Programming and Scripting	7	12-07-2008 09:20 AM
grep string & next n lines	ashterix	Shell Programming and Scripting	8	11-21-2005 11:38 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: