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

CSV, Easy as ABC

Last time I showed you how to create XML documents from PowerShell objects using ConvertTo-XML. PowerShell 2.0 includes a similar cmdlet for creating CSV objects. The Export-CSV cmdlet can still be ...
GitHub

PowerShell program to make file name list in excel with your format automatically

$folder = Get-Location $folder: A variable. PowerShell variables always start with $. =: Assignment operator — assigns the output of the right-hand side to the ...
XDA Developers on MSN

I automated file organization with one PowerShell script

This simple script tamed my Downloads folder.
GitHub

A PowerShell-based script to analyze network logs from CSV files and detect potential beaconing behavior. Supports VirusTotal integration for IP reputation checks.

To analyze firewall logs or CSV-based network data and identify whether certain source-destination IP pairs are beaconing — i.e., communicating at consistent time intervals. You're a SOC analyst ...