Search Array Query (Solved)

[barryb]

Hi All,

I have a simple script that reads in a text file then searches for 3 strings and replaces them if found. All works OK but I have found out another tool that is being used is inserting a space in the strings I'm searching for

I was just going to duplicate what I already have and add the space string but wondered if there was a more eloquent and easily implemented method someone could suggest?

$sWinXP = "<OS VALUE=""WinXP""/>" <--- proper string
$sWinXPb = "<OS VALUE=""WinXP"" />"       <---- string now with added PITA space  
<snip>
        _FileReadToArray($sOSDpath, $aArray)
        _FileWriteLog($file, $sOSDpath & ' Preparing to migrate ')
        $iIndex = _ArraySearch($aArray, $sWinXP, 0, 0, 0, 1)
        If @error Then
            _FileWriteLog($file, $sWinXP & ' was not found in the array, skipping to next OSD file')
        Else
            _FileWriteLog($file, $sWinXP & ' was found in the array at position '& $iIndex & '.')
            $i7Index = _ArraySearch($aArray, $sWin7s, 0, 0, 0, 1)
            If @error Then
                _FileWriteLog($file, $sWin7s & ' was not found in the array, lets add it')
            ; Insert the string with our new value below the searched for string
                $iNew7 = $iIndex+1
            EndIf

Edited March 21, 2011 by barryb

[hannes08]

Hi barryp,

I'm not an expert in Regular Expressions, but there are loads of howtos and forums out there that can help you.

So what you are looking for in AutoIt is StringRegExpReplace

[Melba23]

barryb,

As Hannes123 has pointed out, this problem is trivial for StringRegExp. You will need to run a loop to look through the file array rather than using _ArraySearch, but the end result is the same.

Take a look at this proof of concept script:

; Simulate _FileReadToArray($sOSDpath, $aArray)
Global $aArray[6] = [5, "tom", "<OS VALUE=""WinXP""/>", "dick", "<OS VALUE=""WinXP"" />", "harry"]

For $i = 1 To $aArray[0]
    If StringRegExp($aArray[$i], '<OS VALUE="WinXP"\s{0,1}\/>') Then
        $iIndex = $i
        ExitLoop
    EndIf
Next
If $i = $aArray[0] + 1 Then
    ConsoleWrite("WinXP not found in the array, skipping to next OSD file")
Else
    ConsoleWrite("WinXP found on line " & $iIndex & @CRLF)
EndIf

You should get the "found on line 2" message at first - just alter the first WinXP string and it will find the one with a space in - alter both and it will find neither.

I imagine you have other strings to search for - if you let us have the optional versions for them all we can develop SREs for those too.

M23

[barryb]

Thanks guys! I'm in and out of Autoit so am just a dabbler

What I will do is take your excelent example and advice then see if I can then fit it in to my script, if I'm not back in a week send out the search party

Cheers,

Barry

[barryb]

Hi Guys,

thanks for your input and help, after some hiccups I got it working and now have it out for testing

Cheers,

Barry

[Melba23]

barryb,

Your week was nearly up - the search party was being formed!

Glad you got it working.

M23