Assign Array to a variable

[cesinha87]

Never used Array and I am clueless how to assign the output of the Array to a variable. Essentially what I want to do is assign $db_ServerName to Row 0, $db_DatabaseName to Row 1, $db_port to Row 3

[spudw2k]

You can reference the content of an array by using brackets at the end of the array, and the index of the desired element.

For example $aArrayVariableName[0] would reference the string "WIN2K16" in your array above (using the correct array variable name of course).

This article should tell you everything you need to know about Arrays.
https://www.autoitscript.com/wiki/Arrays

Let us know if you have questions.

 

Just as a recommendation. I find it useful to use Constants to collect info from arrays to make it easier to read the source, and you don't have to keep track of what index numbers represent the contents of an array. This also depends on the accuracy of the array being produced, but additional error checking/logic should help rule out anomalies.

#include <Array.au3>

Const Enum $DB_HOSTNAME, $DB_NAME, $DB_FIELD, $DB_PORT
Local $aTest[4]=['WIN2K16','ePO_WIN2K16','',1433]

Local $db_ServerName = $aTest[$DB_HOSTNAME]
Local $db_DatabaseName = $aTest[$DB_NAME]
Local $db_DatabasePort = $aTest[$DB_PORT]

Msgbox(0,"DB Info",$db_ServerName & @CRLF & $db_DatabaseName & @CRLF & $db_DatabasePort)

Also, depending on your situation, you may not need to go through the work of creating variables which duplicate the values in the array.  Up to you and your needs.

[cesinha87]

It didn't quite work for me. Having a hard time to understand this Array thing. My Array output is assigned to $res

 

 

$read = FileRead($read)
;MsgBox(0, "", $read)
$res = StringRegExp($read, 'db\.(?|server.name|database.name|instance.name|port)=(\N*)', 3)
_ArrayDisplay($res)



Const Enum $DB_HOSTNAME, $DB_NAME, $DB_FIELD, $DB_PORT

Local $res[4]
Local $db_ServerName = $res[$DB_HOSTNAME]
Local $db_DatabaseName = $res[$DB_NAME]
Local $db_DatabasePort = $res[$DB_PORT]

Msgbox(0,"DB Info",$db_ServerName & @CRLF & $db_DatabaseName & @CRLF & $db_DatabasePort)

 

[cesinha87]

What I don't understand is the piece? 

Local $aTest[4]=['WIN2K16','ePO_WIN2K16','',1433]

Here I am declaring 'WIN2k16' and this will change if I run in a different environment. It should get the info coming from the regex and assigned a variable to it

 

Global $read = $file

$read = FileRead($read)
;MsgBox(0, "", $read)
$res = StringRegExp($read, 'db\.(?|server.name|database.name|instance.name|port)=(\N*)', 3)
_ArrayDisplay($res)

[spudw2k]

Remove Local $res[4] from your example.  You are effectively erasing the array returned from your StringRegExp function call.

[spudw2k]

8 hours ago, cesinha87 said:

What I don't understand is the piece? 

Local $aTest[4]=['WIN2K16','ePO_WIN2K16','',1433]

 

That is just an array I created to replicate the contents from your original screenshot. Don't worry about it, just tor demonstration purposes since I didn't know how your array was being generated.  Just use the StringRegExp you got.

[water]

How about _ArrayToString to create a string?

[spudw2k]

@water The OP already has a string that he is parsing into an array using REGEX, and he was asking for help using arrays.  I don't think turning a string into an array and back into a string helps him accomplish that.

[water]

On 8/15/2019 at 3:55 AM, cesinha87 said:

Never used Array and I am clueless how to assign the output of the Array to a variable.

And the title of the thread asks for the same. So he gets what he’s asking for