Get rows from a powershell output

Question

I've got an output like this:

Schema:
  Column Name                   Localized Name                Type    MaxLength
  ----------------------------  ----------------------------  ------  ---------
  RequestID                     Issued Request ID             Long    4 -- Indexed

Maximum Row Index: 0

0 Rows
   0 Row Properties, Total Size = 0, Max Size = 0, Ave Size = 0
   0 Request Attributes, Total Size = 0, Max Size = 0, Ave Size = 0
   0 Certificate Extensions, Total Size = 0, Max Size = 0, Ave Size = 0
   0 Total Fields, Total Size = 0, Max Size = 0, Ave Size = 0
CertUtil: -view command completed successfully.

I need to do something if Rows are equal to 0 and somethingelse if Rows are distinct to 0

If Rows = 0 then
    Write-host "do something"
Else
    Write-host "Do nothing"

How could I get the number of rows into a variable?

Thank you!

mjolinor · Accepted Answer · 2014-04-02 13:25:16Z

1

Using chained -match and -replace operators with your test data:

$text = (@'
Schema:
  Column Name                   Localized Name                Type    MaxLength
  ----------------------------  ----------------------------  ------  ---------
  RequestID                     Issued Request ID             Long    4 -- Indexed

Maximum Row Index: 0

0 Rows
   0 Row Properties, Total Size = 0, Max Size = 0, Ave Size = 0
   0 Request Attributes, Total Size = 0, Max Size = 0, Ave Size = 0
   0 Certificate Extensions, Total Size = 0, Max Size = 0, Ave Size = 0
   0 Total Fields, Total Size = 0, Max Size = 0, Ave Size = 0
CertUtil: -view command completed successfully.
'@).split("`n") |
foreach {$_.trim()} 


$Rows = $text -match '^\d+ Rows\s*$' -replace '^(\d+).+','$1'
$Rows

0

answered Apr 2, 2014 at 13:25

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

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

Collectives™ on Stack Overflow

Get rows from a powershell output

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related