Use Powershell script to count the number of lines in multiple text files

You can use a PowerShell script to count the number of lines in multiple text files saved to a folder.

Enter the file path for the folder after the Get-ChildItem command on the first line. Then specify the extension of the files to be analyzed towards the end of the first line after 'extension - eq'.

Get-ChildItem c:\foofolder\test2 -recurse | where {$_.extension -eq ".txt"} | % {

$_ | Select-Object -Property 'Name', @{

label = 'Lines'; expression = {

($_ | Get-Content).Length

}

}

} | out-file C:\foofolder\test2\lines1.txt

On the last line provide the file path for a new text file to which PowerShell will write the results. Open Windows PowerShell ISE (x86) and then enter the script in a new pane, and then press the play button on the toolbar.

The text file that is generated will list each file name in the source folder and show the number of lines in each in a column to the right.

I ran this script on a set of more than 100,000 text files (which turned out to consist of more than 9 million lines) and it finished the review in less than 30 minutes.

The script can also be used to find the number of lines in other files such as .csv files.

Be sure to enter the file paths in quotes if they include blank spaces.

Thanks to Hari Parkash for posting this script here.

powershell script to get the file size of files in multiple locations

You can run a simple PowerShell script to get the file size of files saved in various locations on a network.

Get-Childitem -file "C:\foofolder\2022.05.31 Fedex Ground.pdf" | select length

Get-Childitem -file "C:\foofolder\Citation\test\XYZ 000400.pdf" | select length

Get-Childitem -file "U:\O'Shea Documents\personal\port st. lucie.heic" | select length

Simply enter the file path in one column of an Excel spreadsheet, with the Get-Childitem -file command in the column to the left, and the | select length operator in the column to the right. Copy the three columns to NotePad and remove the tabs. Enter the script in Windows PowerShell ISE:

It will output the number of bytes in each file. [1924588 equals 1.9 MB]. You can copy the file sizes back into the Excel spreadsheet so they line up with file paths:

Recently, I used this script to get the length of hundreds of Excel files linked to on a spreadsheet for a trial exhibit list that were saved in dozens of different directories, when requested to find if a file was saved on the list under a different Bates number. The closest in size file proved to be a match.

special characters cause batch files to fail

I'm working on a trial right now so my posts will have to be short .

Note that if you use a batch file like the one discussed in the Tip of the Night for July 24, 2020, and the names for the renamed files include any of the special characters:

* . " / \ [ ] : ; | , $ + # % ! @

. . . which cannot be used in the Windows file system, the batch file will fail, and files with those characters will not be copied. To get around this problem, use the PowerShell script described in the Tip of the Night for May 5, 2018.