Search for string in Array

[jamesjames1]

Hi,

I have an array of groups which for troubleshooting is echoing to screen. What I really need to do is search through the array for a particular group name, from here I can construct some type of IF or select statement to run a chunk of code.


Any help would be good.

ta

 

[jasonp45]

Not sure what you're working with but I'll assume each array value is text. Something like this should work:

Dim sSearchString 'as String
Dim MyArray(3) 'as String
MyArray(1) = "Group1"
MyArray(2) = "Group2"
MyArray(3) = "Group3"
sSearchString = "Group2"

For a = 1 to UBound(MyArray)
If MyArray(a) = sSearchString Then MsgBox MyArray(a)
Next

 

[Swi]

Why not store the information in a dictionary and utilizes its .Exists method?

Swi

 

[jamesjames1]

Hi, Thanks for your feedback.

I went with the dictionary.exists method in the end and it was just what I was looking for. Here is what I came up with

Set objDictionary = CreateObject("scripting.dictionary")
objDictionary.Add "comp1", "server1"
'WScript.Echo objDictionary.item ("comp1")

if objDictionary.Exists("comp1") Then

'objDictionary.Item("comp1") = "Guild"
wscript.echo "correct"

elseif objDictionary.Exists("comp2") Then
wscript.echo "not correct"

End If

Seems to work so I will integrate it into my group script..

Thanks

James

 

[strongm]

I think I'd have looked at the Filter function, given you already have the groups in an array