extract from xml file

[Ash (archive)]

My input file is something like this

<DB>
<E>
<TAG1><![DATA[ "ep87" ]]></TAG1>
<TAG2><![DATA[ "0" ]]></TAG2>
<TAG3><![DATA[ "8.8.8.7" ]]></TAG3>
</E>
<E>
<TAG1><![DATA[ "EP7-1" ]]></TAG1>
<TAG2><![DATA[ "0" ]]></TAG2>
<TAG3><![DATA[ "192.168.5.1" ]]></TAG3>
</E>

</DB>

I want to able to search on string ep87 and get the output like

<E>
<TAG1><![DATA[ "ep87" ]]></TAG1>
<TAG2><![DATA[ "0" ]]></TAG2>
<TAG3><![DATA[ "8.8.8.7" ]]></TAG3>
</E>

What tool or script can I use?
Thank You..

 

[Patrick TJ McPhee]

% My input file is something like this
%
% <DB>
% <E>
% <TAG1><![DATA[ "ep87" ]]></TAG1>

This should be [CDATA[

[...]

% I want to able to search on string ep87 and get the output like % % <E> % <TAG1><![DATA[ "ep87" ]]></TAG1> % <TAG2><![DATA[ "0" ]]></TAG2> % <TAG3><![DATA[ "8.8.8.7" ]]></TAG3> % </E>

% What tool or script can I use?

You could do this with xslt:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xslutput method="xml"/>

<xslaram name="ep87" select="'ep87'"/>

<xsl:template match="text"/>

<xsl:template match="TAG1[contains(., $ep87)]">
<xsl:copy-of select="parent::*"/>
</xsl:template>
</xsl:stylesheet>

most (all?) xslt tools will let you set a parameter from the command-line. For instance, with xsltproc, you can run the above with

xsltproc --param ep87 "'EP7-1'" query.xsl data.xml