Powershell: count equal lines in txt file

Question

I need to count the lines with Powershell which are equal in a text file. Also I want to output the lines which appears two or more times just once with the count of occurrences

Example:

My text file:

WD WD3001BKHG-02D22,279.46 GB,SAS,u0 
WD WD3001BKHG-02D22,279.46 GB,SAS,u0 
SEAGATE ST300MM0026,279.39 GB,SAS,u1 
SEAGATE ST9300603SS,279.39 GB,SAS,u1

I want to get the following output with the count of this line:

WD WD3001BKHG-02D22,279.46 GB,SAS,u0,2
SEAGATE ST300MM0026,279.39 GB,SAS,u1,1
SEAGATE ST9300603SS,279.39 GB,SAS,u1,1

Benjamin Hubbard · Accepted Answer · 2015-11-05 16:30:59Z

4

Use Group-Object.

$TextFile | Group-Object

Count Name                      Group                                                                                                                                                          
----- ----                      -----                                                                                                                                                          
    2 WD WD3001BKHG-02D22,27... {WD WD3001BKHG-02D22,279.46 GB,SAS,u0, WD WD3001BKHG-02D22,279.46 GB,SAS,u0}                                                                                 
    1 SEAGATE ST300MM0026,27... {SEAGATE ST300MM0026,279.39 GB,SAS,u1}                                                                                                                        
    1 SEAGATE ST9300603SS,27... {SEAGATE ST9300603SS,279.39 GB,SAS,u1}

answered Nov 5, 2015 at 16:30

Benjamin Hubbard

2,92524 silver badges29 bronze badges

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

1 Comment

mabu Over a year ago

Very helpful answer to me, thanks! Code from my example: $output=($input | Group-Object | Format-Table -AutoSize -HideTableHeaders -Property Name,Count | Out-String)

Collectives™ on Stack Overflow

Powershell: count equal lines in txt file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related