I have a text file that I need to read in PowerShell.
The last character in each row is either a Y or a N.
I need to go through the file and output how many Y's and N's are in there.
Any ideas?
Add a comment
|
6 Answers
Assuming a file named "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 that helps.
1 Comment
Chris Muench
for any googlers that want this answer in a variable here it is [code] $a = (Get-Content filename.txt| Select-String "|Y $" | Measure-Object).count [/code]
To get both the counts in a single line:
gc .\test.txt | %{ if($_ -match "Y$|N$"){ $matches[0]} } | group
Comments
Get-Content test.txt | Where-Object {$_ -match '[YN]$'} | Group-Object {$_[-1]} -NoElement
Comments
$lastchar = @{};get-content $file |% {$lastchar[$_[-1]]++};$lastchar
Comments
I like the answer by @manojlds, so I'll throw something similar:
$grouped = (gc .\test.txt) -replace ".*(y|n)$",'$1' | group
(operators can be used on arrays as well).
Then you can use it like this:
($grouped | ? {$_.Name -eq 'y'}).count
Comments
$(foreach ($line in [IO.File]::ReadAllLines(".\test.txt")) {
$line.Substring($line.Length - 1)
}) | Group
Comments
