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

Import CSV Cleanup into PowerShell

I love using Import-CSV because anything you import will be converted into an object. The source of your CSV file can come from anywhere. It does not have to be created in PowerShell. This is ...