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 ...
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 ...
Ars Technica

Powershell - Exporting multiple variables to CSV or XLS

I have a script where I've done some work and come up with multiple values stored as variables, and I want to be able to export them all to CSV or XLS in a format similar to this: ...
Ars Technica

Powershell to merge 2 csv files together

I have a dataset in 2 CSV files, example: id name site 1 bob wer 1 bob wer 2 jil fgas 3 jack vbcx 3 jack yhte I've looked at join-object http://blogs.msdn.com/b ...
MCPmag

How To Process Multiple CSV Files at Once in PowerShell

Each of these CSV files has four columns: FirstName,LastName,Title,HireDate. At the end of each month, management wants a report of who was hired that month. To find this information, you must read ...
MCPmag

How To Compare a CSV File with Active Directory Users

Using PowerShell, Adam shows you one way to compare a .CSV file full of employee accounts with Active Directory users. So you've been given a .CSV file from your HR department that contains a list of ...