Automatically extract everything from XML file

[craigja]

Hi,

I have an XML file that has around 200 tags in it - I dont really want to have to manually extract every one as I dont know exactly what ones I need, Is there a way of configuring the ParseXML tool to just extract everything from an XML file?

[danilang]

Sorry @craigja 

There's no way to use a single parse xml tool to extract everything from an xml file.  You can

1. build a workflow using a series of xml parse tools similar to Challenge #116: A Symphony of Parsing Tools
2. Import the entire file as a csv and use a combination of formula, multi-row formula tool, and regex_parse tools to get the elements and attributes you need.
3. use python to get the info you need.   

A quick search of the literature returns no method in any language that returns the entire set of data.  The closest that I've found is in C# and even then you need to manually extract the elements you need based on their names.  

Dan

[craigja]

OK, no problem - Im just starting to get to grips with the XML parse tool, I hate working with XML!