1 Reply Latest reply: Oct 25, 2012 11:49 AM by odie_63 RSS

    partial xml display from the an xml

    970697
      hi ,

      I have an xml in the format

      <?xml version="1.0"?>
      <ROWSET>
      <ROW>
      <CLASS> XII A </CLASS>
      <TEACHER> KATE </TEACHER>
      <STUDENT_STRENGTH> 30 </STUDENT_STRENGTH>
      <DESKS> 50 </DESKS>
      </ROW>
      <ROW>
      <CLASS>XII B</CLASS>
      <STUDENT_STRENGTH> 40 </STUDENT_STRENGTH>
      <NUMBER OF GIRLS> 15 </NUMBER OF GIRLS>
      <NUMBER_OF_BOYS> 25 </NUMBER_OF_BOYS>
      </ROW>
      </ ROWSET>

      I need to get a result :

      <?xml version="1.0"?>
      <ROWSET>
      <ROW>
      <CLASS> XII A </CLASS>
      <STUDENT_STRENGTH> 30 </STUDENT_STRENGTH>
      </ROW>
      <ROW>
      <CLASS>XII B</CLASS>
      <STUDENT_STRENGTH> 40 </STUDENT_STRENGTH>
      </ROW>
      </ ROWSET>


      I was trying to get this by using multiple extract but fails miserably.

      Thanks in advance

      Regards
      Ashish Kuruvilla