Create Dynamic array from text file, then run command

[spikeman24]

Hi

I have a vbscript file that includes some functions and that generates a text file as seen below. The next step in my automation quest is to perform a secondary task/command/function of all URL’s containing

http://teamX.qa.thebigtest.com/

Using the example below I would need to run the command on 6 URL’s (the command does not need to run on the first primary URL)

I've been reading about arrays and was wondering how to create a dynamic array for all the site URL's (- the first one) in my text file then may excute the command for every line within the array.

----------------------------------------------------------------------------------
<Sites Count="7">
<Site Url="

http://teamX.qa.thebigtest.com"

Owner="LAB1\fred.sa" />
<Site Url="

http://teamX.qa.thebigtest.com/slirp"

Owner="ITN\bob" SecondaryOwner=" ITN\jack" />
<Site Url="

http://teamX.qa.thebigtest.com/kenny"

Owner=" ITN\jill" />
<Site Url="

http://teamX.qa.thebigtest.com/power_station"

Owner=" ITN\bart" SecondaryOwner=" ITN\maggie" />
<Site Url="

http://teamX.qa.thebigtest.com/friends"

Owner=" ITN\homer" SecondaryOwner=" ITN\mo" />
<Site Url="

http://teamX.qa.thebigtest.com/bar_menu"

Owner="ITN\maggie" SecondaryOwner=" ITN\homer" />
<Site Url="

http://teamX.qa.thebigtest.com/drink_list"

Owner="ITN\lisa" SecondaryOwner=" ITN\maggie" />
</Sites>
----------------------------------------------------------------------------------

I’m new to vbscripting, so any help with this would be greatly appreciated. Also I'm not sure if I have explained myself as best as I can, let me know if I should start again.

Kind Regards

Herschel

 

[PHV]

Take a look at Dim myArray() and at the ReDim Preserve instruction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244