I am in a situation where I need to re-order the sequence of data in an xml file.
To make sure this is clear, we are selling products online and use an xml file to load data to our web system. each item/product has a list of features, up to 10. the first 3 are the main features, then others follow....Each feature has a 'sequence number' that is indicates the order of the features (not necessarily the order they appear in the xml file) The issue I am facing, is this xml file is used for many systems...all of which are able to recognize this sequence number and order the features accordingly. I am in a situation where I need to use this xml file for a new system, on a tight timeline and need to 'process' the xml file to re-order the features for each item so they appear in order in the xml file, and this new system will read them in, in the correct order. Can anyone suggest a tool or method to reorder this data within the xml file? Just looking for a short term fix. One more point I should add. it is highly preferred that I can do this in a somewhat automated day. the goal is to upload this xml file daily (i can get by with doing it weekly for now) but would like it to be as automated as possible. Thanks for any help!