Finding Line number of string in txt file

[BrewManNH]

Seeing as how this is an XML file, you might want to take a look at this UDF that might make it easier than a RegEx.

 

[bounty2k3]

Thank you, I'll read up on it.  It was suggested before, but xml and arrays scare me lol

[bounty2k3]

KingBob,

 

I read that article you directed me to.  Most of it seems to be a discussion on how to write the udf.  Honestly I'd rather stick to regex.  That doesn't mean I don't appreciate your help though.  If there is a way to make regexp work, I'm all for it.  If however someone tells me it can't work no matter what then I guess I'll try to figure out that other article.

 

Thanks, 

Bounty2k3

[BrewManNH]

The link I posted is a download link to the XML UDF that will allow you to get the information from an XML file without having to resort to using a regex. XML files can be read like an INI file using this UDF instead of trying to parse it yourself.

[mikell]

The most convenient way which solves both issues is to use StringRegExp instead of StringRegExpReplace
The results are then stored in an array :

$aResult = StringRegExp($RECORDDATAXML, "<RogNode>(.*?)</RogNode>", 3)

If not IsArray($aResult) Then   ; error checking - no match found
    ; ...    
Else     ; 1 or more matches, could be enumerated using a For loop
    For $i = 0 to UBound($aResult)-1
        Msgbox(0,"", $aResult[$i]
    Next
EndIf

 

[guinness]

OR even better...

$aResult = StringRegExp($RECORDDATAXML, "<RogNode>(.*?)</RogNode>", $STR_REGEXPARRAYGLOBALMATCH)
If @error Then ; Error checking - no match found
    ; ...    
Else
    ; 1 or more matches, could be enumerated using a For loop
    For $i = 0 to UBound($aResult) - 1
        Msgbox($MB_SYSTEMMODAL, "", $aResult[$i])
    Next
EndIf

 

[bounty2k3]

I will try both of those suggestions.  I do have a question though first.  Might make it easier if I ask this first.

Since I'm using RegExpReplace (which has been working very well).  Is there a way to part way through the node make it search for anything before the first >?

I'll give an example.

$SOCODE1 = StringRegExpReplace($GETSOCODES2, "(?s).*<RogComplCd1>(.*)</RogComplCd1>.*", "$1")



Question:

    $SOCODE1 = StringRegExpReplace($GETSOCODES2, "(?s).*<RogComplCd1////here////>(.*)</RogComplCd1>.*", "$1")

where I put in ////here////......   Sort of like (*.*)?

[jdelaney]

Using the regexp is trying to like trying to re-invent a wheel that is xmldom:

$sXML = '<root>' & @CRLF & _
'   <RogEquipSerialNum HasChanged="0">blah</RogEquipSerialNum>' & @CRLF & _
'   <RogEquipSerialNum HasChanged="0">blah2</RogEquipSerialNum>' & @CRLF & _
'   <RogEquipSerialNum HasChanged="1">blah3</RogEquipSerialNum>' & @CRLF & _
'</root>'
Local $oXML = ObjCreate("Microsoft.XMLDOM")
$oXML.loadxml($sXML)
$oSerialNums = $oXML.SelectNodes('//RogEquipSerialNum[@HasChanged="0"]')

For $oSerialNum In $oSerialNums

    ; only enter here if one is found...that solves issue #1
    $oSerialNum.text = $oSerialNum.text & "AppendedText"
Next

; to show the value updated...notice that the 3rd one doesn't update, because the attrib doesn't match
ConsoleWrite($oXml.xml)

console output:

<root>
 <RogEquipSerialNum HasChanged="0">blahAppendedText</RogEquipSerialNum>
 <RogEquipSerialNum HasChanged="0">blah2AppendedText</RogEquipSerialNum>
 <RogEquipSerialNum HasChanged="1">blah3</RogEquipSerialNum>
</root>