Question

I have a simple for loop in powershell to loop through a json response

foreach ($myvar in $response) { 
    $getvalues = $myvar.acc_name
    Write-Host $getvalues
}

产出如下:

abc
abc
www
abc
bbb
abc

我需要增加代码,以计算变数和显示产出的发生情况如下:

abc 4
www 1
bbb 1

Answer 1

Use the Group-Object cmdlet to group the values together - the resulting output will reflect the count of each distinct group:

PS ~> $strings = -split  abc abc www abc bbb abc 
PS ~> $strings |Group-Object -NoElement

Count Name
----- ----
    4 abc
    1 bbb
    1 www

Group-Object还接受比较的计算值:

PS ~> $strings = -split  abc abc www abc bbb abc 
PS ~> $strings |Group-Object {$_[1] <# group only on second letter in each string#> } -NoElement

Count Name
----- ----
    5 b
    1 w

Answer 2

如果投入如此的话:

$test = "abc
abc
www
abc
bbb
abc"

你们可以分开:

$lines = $test -split "`n"

在分类之后:

$groupedLines = $lines | ForEach-Object { $_.Trim() } | Group-Object | ForEach-Object {
[PSCustomObject]@{
    Count = $_.Count
    Value = $_.Name
    }
}

产出:

Count Value
----- -----
4 abc
1 bbb
1 www

如果没有<代码>ForEach-Object{_$_Trim() },你将获得这一产出:

Count Value
----- -----
1 abc
3 abc…
1 bbb…
1 www…

或许,我克服了这一问题:D

友情链接