Help with using data from a 2D array (simple)

[PsychOfMSE]

So this should be very simple for you guys, but I've been banging my head against the wall for a while now and I'm running out of time getting an example script set up.

Basically what i'm doing is using ProgAndy's CSV UDF to parse a CSV with 3 columns and n amount of rows.

The structure of the CSV is:

Hostname           IP          AgentType

TEST001     192.168.1.1     1

TEST002     192.168.1.2     2

TEST003     192.168.1.3     1

TEST004     192.168.1.4     2

 

$Data = _ParseCSV('C:\test.csv', ",", '"', 0)

So now I have a variable, $Data.  What I want to do is create a loop that will go through each row and run a command using data from each column as variables.  It's basically going to be a loop to a RunWait for a program that I'll be inserting the data from each column into the command line syntax as a variable, example:

;If Hostname field is populated but IP field is not use the command:
RunWait('C:\Example.exe -Hostname="TEST001" -AgentType="1"')

;If IP field is populated but hostname is not, use the command:
RunWait('C:\Example.exe -IP="192.168.1.1" -AgentType="1"')

;If both fields are populated default to using the IP address
RunWait('C:\Example.exe -IP="192.168.1.1" -AgentType="1"')

The CSV could have any amount of rows, maybe up to 2000+ rows, but will always have 3 columns.

I'm sure this is an easy solution for you guys, but I'm running out of time and I just can't wrap my head around it.  Arrays are one of the last pieces of AutoIT that is truly evading my comprehension.  I'm the kind of person that learns best by being shown examples that directly relate to my problem and then tailoring that to fit my solution and then memorybanking it for later use.

Thank you all so much!

Edited May 7, 2014 by PsychOfMSE

[BrewManNH]

Something like this?

 

For $Loop = 0 to Ubound($Data) - 1
    If $Data[$Loop][0] <> "" and $Data[$Loop][1] = "" Then ;If Hostname field is populated but IP field is not use the command:
        RunWait('C:\Example.exe -Hostname=' & $Data[$Loop][0] & ' -AgentType=' & $Data[$Loop][2])
    ElseIf $Data[$Loop][1] <> "" Then ;If IP field is populated but hostname is not, use the command:
                                  ;If both fields are populated default to using the IP address
        RunWait('C:\Example.exe -IP=' & $Data[$Loop][1] & ' -AgentType=' & $Data[$Loop][2])
    EndIf
Next

The array elements used would depend on how the _ParseCSV returns the information Edited May 7, 2014 by BrewManNH

[PsychOfMSE]

Something like this?

 

For $Loop = 0 to Ubound($Data) - 1
    If $Data[$Loop][0] <> "" and $Data[$Loop][1] = "" Then ;If Hostname field is populated but IP field is not use the command:
        RunWait('C:\Example.exe -Hostname=' & $Data[$Loop][0] & ' -AgentType=' & $Data[$Loop][2])
    ElseIf $Data[$Loop][1] <> "" Then ;If IP field is populated but hostname is not, use the command:
                                  ;If both fields are populated default to using the IP address
        RunWait('C:\Example.exe -IP=' & $Data[$Loop][1] & ' -AgentType=' & $Data[$Loop][2])
    EndIf
Next

The array elements used would depend on how the _ParseCSV returns the information

 

 

The UDF describes the return as:

; Return values .: Success - 2D-Array with CSV data (0-based)

Being relatively unfamiliar with arrays, your code looks like it should do exactly what I need it to do, and looks to be easy enough to expound upon to add in the additional functionality I want to implement.

As long as that snippet will work with the return value of the _ParseCSV function returns, that looks like exactly what I need...and it clarifies a LOT with arrays for me.  Thank you so much!

[BrewManNH]

I don't know the UDF you're using, and you didn't provide a link, but the snippet I posted should be easy enough to modify to fit if it's not correct.