Count PDF file in zip file

Question

Hi,

I'm looking for a way to get the number of pdf file in zip file

I found this powershell on google :

$ZipRoot = 'C:\ZipFolder\'
$ZipFiles = Get-ChildItem -Path $ZipRoot -Filter *.zip -Recurse

Add-Type -AssemblyName System.IO.Compression.FileSystem
$Results = foreach( $ZipFile in $ZipFiles ){
$PDFCount = ([IO.Compression.ZipFile]::OpenRead($Zipfile.FullName).Entries|where- 
object{$_.Name -like "*.pdf"}).Count

     [pscustomobject]@{
     FullName = $ZipFile.fullname
     PDFCount = $PDFCount



    }

}

 $Results

The result is the count of pdf per zip file.

But my goal is the count of pdf file per folder. for example :

In "Folder 1", there is 4 zip and in each zip, 4 pdf. The result will be 16 pdf for "Folder 1".

Thank you

Answer 1

Maybe not the most elegant way, but it should give you what you asked for:

$ZipRoot = 'C:\ZipFolder\*'

Add-Type -AssemblyName System.IO.Compression.FileSystem
Get-ChildItem -Path $ZipRoot -Filter *.zip -Recurse -File |
    ForEach-Object{
        $PDFCount = ([IO.Compression.ZipFile]::OpenRead($_.FullName).Entries|
            Where-Object{$_.Name -like "*.pdf"}).Count
        [pscustomobject]@{                          # no need for the file name if you only want the number of files by directory
            DirectoryName = $_.directoryname
            PDFCount = $PDFCount
        }
    } |
        Group-Object -Property DirectoryName|
            ForEach-Object{
                $Tot = 0
                $DirectoryName = $_.Name
                $_.Group |
                    ForEach-Object{
                        $Tot += $_.PDFCount
                    }
                [PSCustomObject]@{                  # ignore the original, this one's a summary
                    DirectoryName = $DirectoryName
                    PDFCount = $Tot
                }
            }

Answer 2

Thank you very much @Rich Matheisen , this is what I was looking for.