Count occurrences of a list of ip in a text file

Question

I need to count occurrences in file text of a list ip.

8.8.8.8
8.8.8.8
8.8.8.8
8.8.8.8
8.8.8.8
8.8.8.8
8.8.8.8
8.8.8.8
8.8.8.8
1.1.1.1
1.1.1.1
1.1.1.1
1.1.1.1

I've tried:

Get-Content "C:\listip.txt" | Select-String -Pattern '^(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$' | measure

But I received the total and not the sum of each occurrence. On linux I would have simply used uniq -c

Are you sure you need the regex? If every line contains a single valid IP, then just: Get-Content "C:\listip.txt" | Group -NoElement — jimhark, May 30 '22 at 18:31

zett42 · Answer 1 · 2022-05-30T18:34:23.990

2

As suggested by Santiago Squarzon, simply pipe into Group-Object:

Get-Content "c:\listip.txt" | 
    Select-String -Pattern '^(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$' | 
    Group-Object -NoElement | 
    Select-Object Count, @{ n='IP'; e='Name' }

Output:

Count IP
----- --
    4 1.1.1.1
    9 8.8.8.8

The parameter -NoElement removes the Group property that is output by default by Group-Object, but is not needed for counting only.

I've added Select-Object to rename the Name property to IP, using a calculated property .

If you'd like to correctly sort the unique IPs (i. e. not string sort, but number by number), you might look at this answer.

edited May 30 '22 at 18:34

answered May 30 '22 at 18:27

zett42

25,437
3
35
72

1

Use NoElement? Good idea. – jimhark May 30 '22 at 18:36
@jimhark Thanks! I've already added it after reading your 1st comment. :) – zett42 May 30 '22 at 18:38

Santiago Squarzon · Answer 2 · 2022-05-30T22:03:29.603

The alternative to Group-Object can be using a hash table:

Get-Content C:\listip.txt | & {
    begin { $out = @{} }
    process { $out[$_.Trim()] += 1 }
    end { $out }
}

Output from the anonymous function would be:

Name                           Value
----                           -----
1.1.1.1                        4
8.8.8.8                        9

If you want to filter or target only the lines that match your pattern, you can add an if condition and use the Matching Operator -match:

Get-Content C:\listip.txt | & {
    begin { $out = @{} }
    process {
        # if the line matches this pattern there is for sure no need to `.Trim()`
        if($_ -match '^(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$') {
            $out[$_] += 1
        }
    }
    end { $out }
}

Count occurrences of a list of ip in a text file

2 Answers2