read input file

[grabrail]

Hi

I need my vb script to be able to read a txt file that contains a list of servers, it should take the first name in the list apply it to a variable, run some commands (which i have in place already) then loop round and then read the second name, etc, etc, until there is no names left in the file then finish.

Anyone know how I can achieve this.

Cheers
J

 

[PHV]

Have a look here:

http://msdn.microsoft.com/library/en-us/script56/html/af4423b2-4ee8-41d6-a704-49926cd4d2e8.asp

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

 

[barny2006]

i think this is what you need:

dim filesys, text, readfile, contents, filetoread, wshshell
i = 0
set wshShell = WScript.CreateObject("WScript.Shell")

set filesys = CreateObject("Scripting.FileSystemObject")
filetoread = "c:\my_folder\my_file.txt"
set readfile = filesys.OpenTextFile(filetoread, 1)
do while readfile.AtEndofStream <> true

each_line = readfile.Readline

loop
'''''you can parse each_line and get your data.
msgbox each_line
readfile.close

 

[grabrail]

Cheers that did the trick barny2006

much appreciated