Need help pulling value from XML file

[N00B08]

I am pretty green at this, and not sure how to parse the lines in my XML file to pull back a value. Thus far I am able to open the file, read the lines and trim, but I can't seem to remember how to get the rest.

My goal is to get the IP value so that I can then add it to a UNC path for a backup script.

This is an example of the XML file/format.

<?xml version="1.0" encoding="utf-8"?>

<Variables>

<Variable Name="Server\ServerName">TEST</Variable>

<Variable Name="Server\ServerIP">192.168.1.103</Variable>

<Variable Name="Install\InstallDir">C:\InstallPath</Variable>

<Variable Name="SystemCheck\Operating System\Name">Microsoft Windows XP Professional</Variable>

<Variable Name="SystemCheck\Operating System\ServicePack">3</Variable>

<Variable Name="SystemCheck\Video\Memory">512</Variable>

<Variable Name="Software\Version">3.0.0.2312</Variable>

<Variable Name="Software\Language">English</Variable>

</Variables>

I was hoping someone would be kind enough to help me....?

[PsaltyDS]

You can just parse the strings, or learn to use XPaths:

#include <_XMLDOMWrapper.au3>
#include <Array.au3>

$debugging = True ; Internal debug variable inside _XMLDOMWrapper.au3

$sXML_File = @ScriptDir & "\Test1.xml"
_XMLFileOpen($sXML_File)
$aValue = _XMLGetValue('/Variables/Variable[@Name="Server\ServerIP"]')
If IsArray($aValue) Then
    _ArrayDisplay($aValue, "$aValue")
Else
    ConsoleWrite("Error:  $aArray = " & $aValue & @LF)
EndIf

The more complicated the XML file, the less string parsing you want to do, so eventually you want to learn this stuff.

Edit: Same goes for RegExp! (See UEZ below.)

Edited June 18, 2010 by PsaltyDS

[UEZ]

One solution:

$XML = '<?xml version="1.0" encoding="utf-8"?>' & @LF & _
'<Variables>' & @LF & @LF & _
'<Variable Name="Server\ServerName">TEST</Variable>' & @LF & _
'<Variable Name="Server\ServerIP">192.168.1.103</Variable>' & @LF & _
'<Variable Name="SystemCheck\Operating System\Name">Microsoft Windows XP Professional</Variable>' & @LF & _
'<Variable Name="SystemCheck\Operating System\ServicePack">3</Variable>' & @LF & _
'<Variable Name="SystemCheck\Video\Memory">512</Variable>' & @LF & _
'<Variable Name="Software\Version">3.0.0.2312</Variable>' & @LF & _
'<Variable Name="Software\Language">English</Variable>' & @LF & _
'</Variables>'

$ip = StringRegExp($XML, '"Server\\ServerIP">(.+)</Variable>', 3)
$ip = $ip[0]

ConsoleWrite($ip & @CRLF)

BR,

UEZ

Edited June 18, 2010 by UEZ

[N00B08]

Thank you both for help and the education!!

I was trying the stringregexp route for the past couple hours, but hit a wall.

...or learn to use XPaths:

I was looking for this right before I posted my question. A friend told me to try the xpath route, but he wasn't familiar with autoit, and I couldn't find the right info when I searched.

[Bowmore]

I was looking for this right before I posted my question.  A friend told me to try the xpath route, but he wasn't familiar with autoit, and I couldn't find the right info when I searched.

You might also find it useful to learn XQuery as well. which extends XPath syntax to give similar functionality to using SQL on a database.

For relatively simple XML files without many xml attributes then the _StringBetween() function is a quick and easy way to parse XML