I've build a stringreplace and stringsplit script to give me usable variables when i'm selecting only one row from the table.
However, I need help finding out how I can grab the variables from multiple rows to run a function using only data from one of the columns of those rows
Example. Column A is the element name, column B is the element IP.
I want to select >1 number of rows.
And then run the same command using the data from column B.
exhibit:
Code: Select all
COLUMN A | COLUMN B | JUNK | JUNK | JUNK | JUNK
NAME |192.168.1.1 | Blah | Blah | Blah | Blah
NAMEA |192.168.1.2 | Blah | Blah | Blah | Blah
NAMEB |192.168.1.3 | Blah | Blah | Blah | Blah
NAMEC |192.168.1.4 | Blah | Blah | Blah | Blah
CMD Prompt
Ping 192.68.1.1 -t
New CMD Prompt window
ping 192.168.1.2 -t
New CMD Prompt window
ping 192.168.1.3 -t
New CMD Prompt window
ping 192.168.1.4 -t
etc, etc, etc
I would also like the assigned variables be reusable while the script is running, for example, instead of just pining everything, I want to be able to have the script use those vars to open terminal sessions to, as an example.
Much help appreciated.