I mentioned arrays in a previous post so I figured I should talk about what they are and how to work with them. Now, I’m going to assume that as a DBA you may not really know what an array is (although you probably do) so here is a quick definition:

An array is a data structure that is designed to store a collection of items. The items can be the same type or different types.

An array can have one or more dimensions (a column, a box, a cube etc) and can have a fixed data type or a not. If you don’t have a fixed data type then each element can any type of data. A integer, a string, a horse, etc. Well, maybe not a horse but it can contain any type of coding object. I tend to think of the fixed data type arrays as tables. A single dimension is a single column table, a two dimension table is multi column table, etc. Arrays without a fixed data type are more like excel spreadsheets.

Working with arrays is pretty easy. You declare them with **[]**s or by just assigning a list of elements to a variable. If you are declaring them using **[]**s then one pair will make a single dimension array, two pairs will make a two dimension array etc.

Here are a couple of examples:

[string[]]$TestArray = "Zero","One","Two","Three","Four","Five","Six","Seven","Eight","Nine" #Or $TestArray = "Zero","One","Two","Three","Four","Five","Six","Seven","Eight","Nine"

[string[][]]$TestArray2 = ("Zero,Zero","Zero,One","Zero,Two","Zero,Three")` ,("One,Zero","One,One","One,Two","One,Three")` ,("Two,Zero","Two,One","Two,Two","Two,Three")` ,("Three,Zero","Three,One","Three,Two","Three,Three") #Or $TestArray2 = ("Zero,Zero","Zero,One","Zero,Two","Zero,Three")` ,("One,Zero","One,One","One,Two","One,Three")` ,("Two,Zero","Two,One","Two,Two","Two,Three")` ,("Three,Zero","Three,One","Three,Two","Three,Three")

At this point I should probably point out that arrays are 0 based. By that I mean the first element of an array is the 0 element not the 1 element. A bit confusing if you ask me but you’ll get used to it. Now, to reference an element you just have to put the position number in the **[]**s. The strings I put in the arrays are there so that it’s really obvious that I’m getting back the right values.

$TestArray[2] Two $TestArray[7] Seven $TestArray2[2][1] Two, One $TestArray2[0][3] Zero, Three

Now here’s where it gets interesting. This is Powershell, and one of the things that makes Powershell so .. well .. Powerfull .. is that you can pass multiple elements to a command and it will process it for each of them. So to do that we need to be able to get multiple elements back.

All elements

$TestArray2 Zero,Zero Zero,One Zero,Two Zero,Three One,Zero One,One One,Two One,Three Two,Zero Two,One Two,Two Two,Three Three,Zero Three,One Three,Two Three,Three

Multiple elements in a row

$TestArray[3..7] Three Four Five Six Seven

Multiple elements that aren’t in a row

$TestArray2[0,2][1] Zero, One Two, One $TestArray2[0][1,3] Zero, One Zero, Three

Where this got really weird is that I couldn’t figure out how to pull multiple elements from both parts of the array at once. For example this didn’t return what I expected.

$TestArray2[0,2][1,3] Two, Zero Two, One Two, Two Two, Three

Obviously I’m still pretty new at this so if I’m missing something or I’m flat out wrong somewhere feel free to make a note in the comments below and I’ll update the post