Best way to do this!

[Sunit Joshi]

Hello All
I have a situation where I need to compare a couple of XML files like
this:

<?xml version="1.0"?>
<MODELS>
  <SITE_ID>DALLAS</SITE_ID>
  <MODEL>
    <MODEL_NO>pipea1m1</MODEL_NO>
    <REVISION_DATE>985118624</REVISION_DATE>
    <DISCIPLINE_INDX_NO>1</DISCIPLINE_INDX_NO>
  </MODEL>
  <MODEL>
</MODELS>

and then write out a final xml file like:

<?xml version="1.0"?>
<Models>
  <Model>
    <modelNo>pipea1m1</modelNo>
    <discipline>1</discipline>
    <Site>
      <ID>Houston</ID>
      <Status>Not Present</Status>
    </Site>
    <Site>
      <ID>Dallas</ID>
      <Status>Present</Status>
    </Site>
    <Latest>Is at Dallas</Latest>
    <Oldest></Oldest> 
  </Model>
</Models>

I was wondering what would be the best way to do this. Any pointers
are greatly appreciated.

thanks
Sunit