Dizzastaffy Posted August 7, 2016 Share Posted August 7, 2016 Hi I am a bit stuck with reading an XML file, I can get most of it to work but one thing I cant work out. This is an example of my data file for ease. <XML> <Check ID="123" Name="test"> <Detail> <Data ID="456" ID2="567"> <Title> This is the title <Other> <Check ID="678" Name="test"> <Detail> <Data ID="999" ID2="666"> <Title> This is the title2 <Other> I have the following code working that gets the ID and ID2 from the Data section within (XML/Check/Data), but I just cant work out how do I get the title for each Data entry ID I extract. It doesn't have an element I can use.? $sFile = "myfile.xml" $oXML = ObjCreate("Microsoft.XMLDOM") $oXML.load($sFile) $xmlquery = $oXML.SelectNodes('//XML//Check/Detail/Data') For $xml In $xmlquery $id = $xml.GetAttribute("ID") $id2 = $xml.GetAttribute("ID2") ConsoleWrite($id & $id2 & @CRLF) Next This works and I get back "456" and "567", "999", "666" etc as it loops, but I also want the Title values for each one. Any suggestions please? thanks Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now