delete xml elements - using xpath search

[Tharanga Abeyseela]

Hi guys,


i need to delete the following pattern and its parent node from my xml
file (IF THE SEARCH STRING FOUND)

<Rating>NC</Rating>

if i find the above particular string , i need to delete the XML
elements (parent of the <Rating> element. problem is i have different
parent nodes with different names..

like

<movies>
<name> xxx</name>
<title>xxx </title>
<Rating>NC</Rating>
</movies>

<tvshow>
<name> </name>
<title>xxx </title>
<Rating>NC</Rating>
</tvshow>

<tvepisode>
<name>xxx </name>
<title>xxx </title>
<Rating>M</Rating>
</tvepisode>


as an example, i need to remove <movies> section and <tvshow> section
from my xml, (because it has the word NC) but need to keep <tvepisode>

can someone point me to the correct direction, or code snippet

Thanks in advance
tharanga