Xml filtering

1

This probably has a simple solution.

I have a xml list here. I want to filter out the players by the active tag. All players where the active tag reads “No” I want to delete so that the list only has players with the acrive tag reading “yes”

Thanks in advance

<playerlist>
<player>
<name>George</name>
<position>Defence</position>
<active>no</active>
</player>

                 &lt;player&gt;
                    &lt;name&gt;Bill&lt;/name&gt;
                   &lt;position&gt;Defence&lt;/position&gt;
                    &lt;active&gt;Yes&lt;/active&gt;
                 &lt;/player&gt;


                 &lt;player&gt;
                    &lt;name&gt;Bill&lt;/name&gt;
                   &lt;position&gt;Offense&lt;/position&gt;
                    &lt;active&gt;Yes&lt;/active&gt;
                 &lt;/player&gt;

                     &lt;player&gt;
                    &lt;name&gt;Henry&lt;/name&gt;
                   &lt;position&gt;Offense&lt;/position&gt;
                    &lt;active&gt;No&lt;/active&gt;
                 &lt;/player&gt;





            &lt;/playlist&gt;;