powershell get content from command output

Question

i have output from external command, like as:

Status  Pool name                 Media Type        MS   # of media   Free [MB]
===============================================================================
Good    pool1           LTO-Ultrium       No         303   298066893
Good    pool2           LTO-Ultrium       No           1     1525878
Good    pool3           LTO-Ultrium       No         282   348735361
Good    pool4           LTO-Ultrium       No         473   588150645

i need parse in PowerShell "pool1", "pool2", "pool3" ... and run command in foreach... any idea for this, without exporting output to xml, csv & etc ? thanks

and, Q2, is here same, or similar way for parsing these:

Good   [QGHL5MMA] QGHL5MMA              [pool1:   322]            No   None              
Good   [QGHL5N2Y] QGHL5N2Y              [pool1:   922]            No   None              
Good   [QGHL5MUL] QGHL5MUL              [pool1:   621]            No   None

From this output, i need only text from column 5 ( 322, 922, 621... ). thanks again

poiu2000 · Accepted Answer · 2013-12-14 06:16:40Z

4

I put the content into a file test.txt and did a try as below:

gc .\test.txt | select-string '.*pool\d+.*' | foreach { $pool = ($_  -split '\s+')[1];write-host $pool;}

And the output:

pool1
pool2
pool3
pool4

In the command line I search the lines which has the pattern as 'pool' followed by digits, and then split it using whitespace as delimiter, then you can get the name 'pool1' etc. to do the things you want.

answered Dec 14, 2013 at 6:16

poiu2000

9802 gold badges15 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mjolinor · Accepted Answer · 2013-12-14 11:12:25Z

1

If you create objects, you can do all kinds of Powershell things with them when you're done. Powershell is all about the objects.

Using your sample data and Powershell V3

$CommandData = 
(@'
Status  Pool name                 Media Type        MS   # of media   Free [MB]
===============================================================================
Good    pool1           LTO-Ultrium       No         303   298066893
Good    pool2           LTO-Ultrium       No           1     1525878
Good    pool3           LTO-Ultrium       No         282   348735361
Good    pool4           LTO-Ultrium       No         473   588150645
'@).split("`n") |
foreach {$_.trim()}

$CommandData | 
 foreach {
  $Props = &{$args} Status Pool Media Type MS No Free[MB]
  if ($_ -match '\d+\s*$')
   {$Parts = $_ -split '\s+'
    $Hash = [ordered]@{}
    for ($i=0; $i -le 5; $i++)
     {$Hash[$Props[$i]] = $Parts[$i]}
    [PSCustomObject]$Hash
    }
   } | | Format-Table -AutoSize


Status Pool  MediaType   MS No  Free[MB] 
------ ----  ---------   -- --  -------- 
Good   pool1 LTO-Ultrium No 303 298066893
Good   pool2 LTO-Ultrium No 1   1525878  
Good   pool3 LTO-Ultrium No 282 348735361
Good   pool4 LTO-Ultrium No 473 588150645

answered Dec 14, 2013 at 11:12

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

1 Comment

g0mez Over a year ago

i need study your example - i am new in arrays,hash & etc. But i think, i dont have another way for another part of script...

bouvierr · Accepted Answer · 2013-12-14 15:33:58Z

0

A simple regex will capture the result.

gc .\table.txt | sls '\s+(pool\d+)\s+' | % {$_.Matches.Groups[1].Value}

edited Dec 14, 2013 at 15:33

answered Dec 14, 2013 at 6:31

bouvierr

3,8603 gold badges30 silver badges36 bronze badges

Collectives™ on Stack Overflow

powershell get content from command output

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related