Hi Everyone
I need to combine two sets of data (File A and File B). The structure is as
follows (snippet):
FILE A:
<supplements>
<supp>
<supp-desc>Half Board</supp-desc>
<supp-price>#10</supp-price>
</supp>
<supp>
<supp-desc>All Inclusive</supp-desc>
<supp-price>#20</supp-price>
</supp>
<supp>
<supp-desc>Sea View</supp-desc>
<supp-price>#3</supp-price>
</supp>
...
</supplements>
FILE B:
<supplements>
<supp>
<supp-desc>Half Board</supp-desc>
<supp-price>#20</supp-price>
</supp>
<supp>
<supp-desc>All Inclusive</supp-desc>
<supp-price>#40</supp-price>
</supp>
<supp>
<supp-desc>Balcony</supp-desc>
<supp-price>#5</supp-price>
</supp>
...
</supplements>
REQUIRED OUTPUT:
<supplements>
<supp>
<supp-desc>Half Board</supp-desc>
<supp-price source="filea">#10</supp-price>
<supp-price source="fileb">#20</supp-price>
</supp>
<supp>
<supp-desc>All Inclusive</supp-desc>
<supp-price source="filea">#20</supp-price>
<supp-price source="fileb">#40</supp-price>
</supp>
<supp>
<supp-desc>Sea View</supp-desc>
<supp-price source="filea">#3</supp-price>
<supp-price source="fileb">-</supp-price></supp>
<supp>
<supp-desc>Balcony</supp-desc>
<supp-price source="filea">-</supp-price>
<supp-price source="fileb">#5</supp-price></supp>
...
</supplements>
DESCRIPTION:
I need to compare <supp> nodes based on the text value of <supp-desc>. If the
<supp> exists in both files then the <supp-price> node from File B is added
underneath the <supp-price> node from File A (a "source" attribute is also
added). If the <supp> exists in one file but not the other, a <supp-price>
node with the text value of "-" is added. "Sea View" and "Balcony" are
examples of <supp> being present in one file only.
Any suggestions on how best to achieve the desired result will be greatly
appreciated.
--
Kevin Bird
|