Redmond Magazine

How To Use .CSV Files with PowerShell, Part 2

In the second part of this series, Brien shows how to import a .CSV file into a PowerShell array, including two methods for zooming in on just the specific data you need and filtering out the rest. In ...
MCPmag

Creating CSV Files with PowerShell

Storing data in a structured way is important when that data will be read by a computer. One of the easiest ways to put data into an easy-to-read format is with a comma-separated value (CSV) file. A ...
Ars Technica

Powershell. Using add-member within an array.

I’m making a new Powershell inventory script. I already have one, but I’m fiddling with the arrays to see if I can make the code a little prettier. I can make variables that have custom members with ...
MCPmag

Managing Arrays in PowerShell

In PowerShell and many languages, an array is a set of items all represented by a single variable. To explain arrays and how to manage them in PowerShell, let's start with the example of a set of ...
Ars Technica

Powershell. Display a 2-dimensional array in tabular format.

I'm learning a little about graph theory and got sidetracked into Powershell text formatting. I'm writing a script that creates a two-dimensional array based on user input and displays the array in a ...
Houston Chronicle

How to Append a PowerShell Output to an XLS Excel File

System administrators and power users utilize Windows PowerShell to perform all sorts of advanced and administrative tasks. With PowerShell, administrators can execute powerful scripting programs or ...
Redmond Magazine

How To Use .CSV Files with PowerShell, Part 1

Windows PowerShell is probably best-known for its ability to allow Windows admins to operate at scale. For instance, it would take forever to create a thousand user accounts through the GUI, but ...