Powershell equivalent for unix command "Uniq -c"

Question

I would like to display the multiple lines with the number of frequencies for a file output. I need that for the Powershell as a one-liner. It should work as a one-liner like under unix with "uniq -c". This is not possible with

gc file.log | sort | get-unique

But I see only one line?

JensG
– JensG

2020-10-28 12:44:09 +00:00
Commented Oct 28, 2020 at 12:44 — JensG
– JensG, Commented Oct 28, 2020 at 12:44
I use a file, where many items are included.

Michael
– Michael

2020-10-28 15:34:17 +00:00
Commented Oct 28, 2020 at 15:34 — Michael
– Michael, Commented Oct 28, 2020 at 15:34

marsze · Accepted Answer · 2020-10-28 15:54:31Z

3

Are you probably looking for Group-Object? It will include the Count of occurrences for each item:

gc file.log | group -NoElement | sort Count -Desc

Note that PowerShell works with objects, not text. So the result is actually a list of objects that have a Count and a Name property. Powershell tries its best to display the objects along with their properties in the console in a readable format and therefore truncates some of the values (for display only).

If you want the plain-text output exactly as in linux, you can add this:

gc file.log | group -NoElement | sort Count -Desc | foreach { "{0} {1}" -f $_.Count, $_.Name }

I would not recommend doing this though, if you want to process the results further. Working with objects, not text, is the "PowerShell way".

edited Oct 28, 2020 at 15:54

answered Oct 28, 2020 at 12:55

marsze

17.5k6 gold badges59 silver badges67 bronze badges

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

3 Comments

Michael Over a year ago

That seems fine, but ir cut the elements of the file: For Example the output looks like: Count Name ----- ---- 1 c:\Windows\WinSxS\amd64_… 1 c:\Windows\WinSxS\amd64_… 1 c:\Windows\WinSxS\amd64_… 1 c:\Windows\WinSxS\wow64_… The Input of the file are Filenames with the whole path. I need the whole path with filename in the result.

Michael Over a year ago

this solution works very good for me. Thanks a lot !!

9 Guy Mar 11 at 14:45

You can also pipe Select-String -Pattern "REGEX" after the gc command if so needed

Collectives™ on Stack Overflow

Powershell equivalent for unix command "Uniq -c"

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related