How to count the number of lines in powershell

Question

I have a text file that I need to read in Powershell.

the last character in each line is either Y or N.

I need to go through the file and print how many Y and N are there.

Any ideas?

Answer 1

Assuming a file called "test.txt" ... To get the number of lines ending in Y, you can do this:

get-content test.txt | select-string Y$ | measure-object -line

And to get the number of lines ending in N, you can do this:

get-content test.txt | select-string N$ | measure-object -line

Hope this helps.

Answer 2

To get both accounts on the same line:

gc .\test.txt | %{ if($_ -match "Y$|N$"){ $matches[0]} } | group

Answer 3

Get-Content test.txt | Where-Object {$_ -match '[YN]$'} | Group-Object {$_[-1]} -NoElement

Answer 4

$lastchar = @{};get-content $file |% {$lastchar[$_[-1]]++};$lastchar

Answer 5

@manojlds, :

$grouped = (gc .\test.txt) -replace ".*(y|n)$",'$1' | group

( ).

Then you can use it as follows:

($grouped | ? {$_.Name -eq 'y'}).count

Answer 6

$(foreach ($line in [IO.File]::ReadAllLines(".\test.txt")) { 
    $line.Substring($line.Length - 1)
}) | Group