XML : Parse XML with modification blocks

I have a strangely structured XML source file. This file contains information of various entities, and it is constantly updated. However, instead of providing a newer version of changed entity, this XML file keeps the modifications. Let me explain by example. Say we have an original entity node

  <identity ssid="1">   <name>    <value>Lukashenka</value>   </name>  </identity>    

later changed to

  <identity ssid="1">   <name>    <value>Lukashenko</value>   </name>  </identity>    

In this XML, it will look like

  <identity ssid="1">   <name>    <value>Lukashenka</value>   </name>  </identity>  <modification>   <removed>    <identity ssid="1">     <name>      <value>Lukashenka</value>     </name>    </identity>   </removed>   <add>    <identity ssid="1">     <name>      <value>Lukashenko</value>     </name>    </identity>   </add>  <modification>    

I never worked with this kind of format before and would like to change this xml file to a normal xml format so that I can import it into Excel. I don't have a solid programming background, but if you are sure about the correct way to transform this file I wouldn't mind a try. Thanks in advance.

No comments:

Post a Comment