topic script to search an xml file and output all sections containing input string..... in Operating System - Linux

script to search an xml file and output all sections containing input string.....

Bill McNAMARA_1 — Thu, 12 Aug 2010 12:10:39 GMT

Hi all,

I'm looking for a way to query an xml file for a particular property with content such as follows:

91

The result of the query for

script.sh 12345

for example would be

91

How could this be done with sed/awk and other standard tools!

Thanks for any help suggestions.
Regards,
Bill

Re: script to search an xml file and output all sections containing input string.....

H.Becker — Thu, 12 Aug 2010 16:20:11 GMT

This one works for me:
$ cat x.sh
#! /bin/sh
awk "BEGIN {RS=\"\"} /.*$1.*/ {printf \$0\"\"} END {printf \"\n\"}" $2
$
$ ./x.sh 12345 x.x

91

$

Re: script to search an xml file and output all sections containing input string.....

James R. Ferguson — Thu, 12 Aug 2010 19:58:30 GMT

Hi Bill:

# cat ./myfilter
#!/usr/bin/perl
use strict;
use warnings;
my $pattern = shift or die;
undef $/;
my $xml = ;
for ( split( //, $xml ) ) {
print "", $_ if m/=$pattern>/;
}
1;

...run as:

# ./myfilter 12345 file

91

Regards!

...JRF...

Re: script to search an xml file and output all sections containing input string.....

Bill McNAMARA_1 — Fri, 13 Aug 2010 03:47:12 GMT

Hi,
Great thanks for your rapid answers.
James, I got an error with your script with the input.xml shown above...

My perl isn't good enough to correct it yet!

[root@oces01 scripts]# ./searchCDR.2.sh 12345 cdr.xml
Name "main::DATA" used only once: possible typo at ./searchCDR.2.sh line 6.
readline() on unopened filehandle DATA at ./searchCDR.2.sh line 6.
Use of uninitialized value in split at ./searchCDR.2.sh line 7.

Re: script to search an xml file and output all sections containing input string.....

James R. Ferguson — Fri, 13 Aug 2010 11:31:12 GMT

Hi (again) Bill:

> James, I got an error with your script with the input.xml shown above...

Yes, my apologies. Change the line that reads:

my $xml = ;

...to be:

my $xml = <>;

The use of allowed me to include your actual data as a part of the script by adding it at the script's end with the prepended line '__DATA__'. When I dropped this I meant to make the change above to enable one or more files to be read from the command line.

Regards!

...JRF...