CSV output for easier PowerShell scripting

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

PowerShell has this great facility for manipulating objects.  Whenever we need to script the output of a SysInternals utility we have to parse text which is brittle and ugly code.  Rather than do this: 
$openFiles = @(handle $env:TEMP | Foreach {($_ -split ": ")[3]} | Select -Unique)

I'd love to be able to do this:

$openFiles = @(handle $env:TEMP -fo CSV | Import-Csv |Select Path -Unique)

Edited by r_keith_hill - 06 April 2012 at 7:24am

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
r_keith_hill Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Newbie Joined: 08 November 2006 Status: Offline Points: 9	Post Options Post Reply Quote r_keith_hill Report Post Thanks(0) Quote Reply Topic: CSV output for easier PowerShell scripting Posted: 06 April 2012 at 6:21am
	PowerShell has this great facility for manipulating objects. Whenever we need to script the output of a SysInternals utility we have to parse text which is brittle and ugly code. Rather than do this: $openFiles = @(handle $env:TEMP \| Foreach {($_ -split ": ")[3]} \| Select -Unique) I'd love to be able to do this: $openFiles = @(handle $env:TEMP -fo CSV \| Import-Csv \|Select Path -Unique) Edited by r_keith_hill - 06 April 2012 at 7:24am

cliffburger Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 06 April 2012 Location: United States Status: Offline Points: 1	Post Options Post Reply Quote cliffburger Report Post Thanks(0) Quote Reply Posted: 06 April 2012 at 7:07am
	+1