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