[solved] RegExpReplace assist, or XPath to Comment Node

[jdelaney]

I have an XML file, which is the output of all the local stations scheduled tasks.

It spits it out like the following:

<!-- Auto10182012142651 -->

<Task version="1.2" xmlns="http://schemas.microsoft.com/windows/2004/02/mit/task">

...lots of data

<Task>

What I need is to grab Auto10182012142651, and place it as a node under <Task>...why microsoft would put the task name outside of the Task is beyond me, but whatever.

1) If you know of a way to grab a comment VIA XPaths, that would work for me, or

2) I'm trying to create a RegExpReplace to change the above to look like this:

<Task version="1.2" xmlns="http://schemas.microsoft.com/windows/2004/02/mit/task">

<Name>Auto10182012142651</Name>

...lots of data

<Task>

I have this, as a jumping off point, but have problems in general...suggestions are welcome

Xpath route

$string = '<Tasks>' & @crlf & _
'<!-- Adobe Flash Player Updater -->' & @crlf & _
'<Task version="1.1" xmlns="http://schemas.microsoft.com/windows/2004/02/mit/task">' & @crlf & _
'<Node>test</Node>' & @crlf & _
'</Task>' & @crlf & _
'</Tasks>'
; XML route
$oXML = ObjCreate("Microsoft.XMLDOM")
$oXML.loadXML($string)
$oCommentNodes = $oXML.selectNodes('//comment()') ; grab all comments
For $oComment In $oCommentNodes
$oXML2 = ObjCreate("Microsoft.XMLDOM")
$oXML2.loadXML($oComment.XML)
;ConsoleWrite ( $oXML2.baseURI & @CRLF )
;ConsoleWrite ( $oXML2.localName & @CRLF )
;ConsoleWrite ( $oXML2.name & @CRLF )
ConsoleWrite ( $oXML2.namespaceURI & @CRLF )
ConsoleWrite ( $oXML2.nodeName & @CRLF )
ConsoleWrite ( $oXML2.nodeType & @CRLF )
ConsoleWrite ( $oXML2.nodeValue & @CRLF )
;ConsoleWrite ( $oXML2.textContent & @CRLF )
ConsoleWrite ( $oXML2.text & @CRLF )
;ConsoleWrite ( $oXML2.value & @CRLF )
Next

regexp route

$string = '<Tasks>' & @crlf & _
'<!-- test1 -->' & @crlf & _
'<Task version="1.1" xmlns="http://schemas.microsoft.com/windows/2004/02/mit/task">' & @crlf & _
'<Node>test</Node>' & @crlf & _
'</Task>' & @crlf & _
'<!-- test2 -->' & @crlf & _
'<Task version="1.1" xmlns="http://schemas.microsoft.com/windows/2004/02/mit/task">' & @crlf & _
'<Node>test</Node>' & @crlf & _
'</Task>' & @crlf & _
'</Tasks>'


$string = StringRegExpReplace ( $string, "<!-- (.*) -->[s]+(<Task[W|w]+mit/task"">)", "2" & "<Name>1</Name>" )
MsgBox ( 1,1,$string )

edit: solved with regexp:

$string = StringRegExpReplace ( $string, "s?<!-- (.*) -->s+(.*)s+", "2" & "<Name>1</Name>" )

...and xpath...

$oXML = ObjCreate("Microsoft.XMLDOM")
$oXML.loadXML($string)
$oCommentNodes = $oXML.selectNodes('//comment()') ; grab all comments
For $oComment In $oCommentNodes
 ConsoleWrite($oComment.text & @CRLF)
Next

just needed to step back for a min

Edited October 19, 2012 by jdelaney