|Yes, I was using the "Set" command more help in command prompt at set /? to set a variable called computerlist to point to a text file called list.txt that would contain a list of computer names or webservers(i.e. www.google.com).|
Then I was porting the Echo command out to final.csv which is a comma seperated value's file. Which means that it see's comma's as the trigger to move to the next column, so you are right. Computernames,IP addresses fed into a .csv file would create the headers of columns in the spreedsheet.
Then the setlocal command - help in the command prompt at, you've probably guessed it, setlocal /?, which in a nut shell allows a variable to be set and used in the for command, you can read the help file for delayed expansion at the end of the "set" helpfile, it can explain it better then I can.
Then if you follow the flow of how response 9 run's it grabs a computer name out of the list.txt, uses the ping command to ping the computername once, and ports the ping command through the "Findstr" command to find the string Reply, the down fall of that is, if the ping gets no reply it will skip over that computer,
But then it sets the Computername to a variable called %%A and the IP address to %%B coming out of the findstr command the IP address has a : at the end, so I set %%B as a delayed variable and used a variable modifier (:~0,-1)to remove the last charactor (:)
then agian used the echo command to port it to the .csv, but this time using double >> to append it to the end of the file, instead of creating a new file.