Help with reading from XML file...

[Terry Olsen]

I'm using the following to pull a string from an XML Log file:

Public Sub ReadXMLFile()
Dim xmlDoc As New XmlDocument
xmlDoc.Load("d:\test.xml")
Dim DriveError As String
=xmlDoc.SelectSingleNode("/joblog/backup/set/directory/directory/directory/drive_error").InnerText
MsgBox(DriveError)
End Sub

However, the "drive_error" part of the node could be any number of
"directory"'s deep depending on where the error occurred during the
backup.

Is there a wildcard or some other way I could grab the drive_error text
regardless of how deep it is?

Thanks.

[Oleg Tkachenko [MVP]]

Terry Olsen wrote:

I'm using the following to pull a string from an XML Log file:

Public Sub ReadXMLFile()
Dim xmlDoc As New XmlDocument
xmlDoc.Load("d:\test.xml")
Dim DriveError As String
=xmlDoc.SelectSingleNode("/joblog/backup/set/directory/directory/directory/drive_error").InnerText
MsgBox(DriveError)
End Sub

However, the "drive_error" part of the node could be any number of
"directory"'s deep depending on where the error occurred during the
backup.

Is there a wildcard or some other way I could grab the drive_error text
regardless of how deep it is?

Sure - /joblog/backup/set//drive_error

--
Oleg Tkachenko [XML MVP, MCP]
http://blog.tkachenko.com