powershellarchivepowershell-v5.1

Update zipfiles with PowerShell 5 or >. Working code looking for improvement


Windows 10 64-bit. PowerShell 5.1

Update zipfiles with PowerShell 5 or >. Working code looking for improvement.

1.1.txt, 1.1.3.txt and 1.txt go in                   FileGroup0000000001.zip
11.txt and 11.1.txt goes in                          FileGroup0000000011.zip 
2.1.3.6.txt, 2.1.3.6.7.txt, 2.1.txt, and 2.txt go in FileGroup0000000002.zip 

Update zipfiles with PowerShell 5 gci, regex, $Matches, foreach {$_ PadLeft}, Compress-Archive, and Remove-Item. Avg 29ms 9 files (48KB) 3 archives on ten runs.

For testing clear your desktop. There should be no .txt or .zip files on your desktop. There are 3 Remove-Item without -whatif or -confirm. Makes 9 text files and three zipfiles. Working script, test script, script w/ logfile.

#credit stackoverflow.com/a/60666329/8826818
pushd %USERPROFILE%\Desktop 
gci *.txt | where BaseName -match "^(\d+)(\.\d+)*$" | group { $Matches[1] } | foreach {
$dest = 'FileGroup' +  $_.Name.PadLeft(10, "0") + ".zip"
Compress-Archive $_.Group $dest -ea Stop -update
ri $_.Group} 
popd

Make test files and test:

pushd %USERPROFILE%\Desktop 
ni @("1.1.txt", "1.txt", "11.txt", "2.1.3.6.txt", "2.1.txt","2.txt") > $null
gci *.txt | where BaseName -match "^(\d+)(\.\d+)*$" | group { $Matches[1] } | foreach {
$dest = 'FileGroup' +  $_.Name.PadLeft(10, "0") + ".zip"
Compress-Archive $_.Group $dest -ea Stop -update
ri $_.Group} 
ni @("1.1.3.txt", "11.1.txt", "2.1.3.6.7.txt") > $null
gci *.txt | where BaseName -match "^(\d+)(\.\d+)*$" | group { $Matches[1] } | foreach {
$dest = 'FileGroup' +  $_.Name.PadLeft(10, "0") + ".zip"
Compress-Archive $_.Group $dest -ea Stop -update
ri $_.Group}
Read-Host @" 

Delete all FileGroup*.zip is next.
There should be nine files in three archives.
Press enter key to delete all test files
"@
ri FileGroup*.zip
# clear-variable -name ("Matches", "dest")
popd 
#

Make test files, ten run loop with logfile:

If(test-path logfile031822_030657692.txt) {
cls 
Write-Output "`r`nOverwrite logfile031822_030657692.txt?`r`nPress any key to continue ...    "
cmd /c pause> nul} 
$zcommandpath=$MyInvocation.MyCommand.Path
Write-Output "`r`nThis is $zcommandpath`r`nHow long to archive 9 text files.`r`nStarted: "((get-date).ToString('MM/dd/yy hh:mm:ss.ffff tt') -replace " : ", ":") | out-file -nonewline -append logfile031822_030657692.txt
$times=@()
$watch = New-Object System.Diagnostics.Stopwatch
for ($zdoug=0;$zdoug -lt 10; $zdoug++){
$watch.Start() #put this at start of the loop
ni @("1.1.txt", "1.txt", "11.txt", "2.1.3.6.txt", "2.1.txt","2.txt") > $null
gci *.txt | where BaseName -match "^(\d+)(\.\d+)*$" | group { $Matches[1] } | foreach {
$dest = 'FileGroup' +  $_.Name.PadLeft(10, "0") + ".zip"
Compress-Archive $_.Group $dest -ea Stop -update
ri $_.Group} 
ni @("1.1.3.txt", "11.1.txt", "2.1.3.6.7.txt") > $null
gci *.txt | where BaseName -match "^(\d+)(\.\d+)*$" | group { $Matches[1] } | foreach {
$dest = 'FileGroup' +  $_.Name.PadLeft(10, "0") + ".zip"
Compress-Archive $_.Group $dest -ea Stop -update
ri $_.Group} 
$times += $watch.Elapsed.TotalSeconds #this at the end
$watch.reset() } 
$zLoopFinished=((get-date).ToString('MM/dd/yy hh:mm:ss.ffff tt') -replace " : ", ":") 
# clear-variable -name ("Matches", "dest", "i") 
# BEGIN DEBUG
# Read-Host @" 
# Delete all FileGroup*.zip is next.
# Press enter key to delete all test files
# "@
#END DEBUG 
ri FileGroup*.zip
popd
#
$times | Measure-Object -sum -ave -max -min
$times | Measure-Object -sum -ave -max -min | out-file -append logfile031822_030657692.txt    
Write-Output "Finished:  $zLoopFinished" | out-file -append logfile031822_030657692.txt    
(gc logfile031822_030657692.txt) | Where { $_.Trim(" `t") }  | select-string -pattern "Property :" -notmatch | out-file logfile031822_030657692.txt
#https://devblogs.microsoft.com/scripting/trim-your-strings-with-powershell/
$NewLine = gc logfile031822_030657692.txt | ForEach-Object {
$_ 
if ($_ -match ('^' + [regex]::Escape( 'Finished:' ))){ " " }}
$NewLine | Out-File logfile031822_030657692.txt -Force 
# 

LogFile:

This is 
How long to archive 9 text files.
Started: 03/15/20 02:56:34.4380 PM
Count    : 10
Average  : 0.38522078
Sum      : 3.8522078
Maximum  : 1.6380882
Minimum  : 0.2281335
Finished:  03/15/20 02:56:39.9413 PM    

How to parse file path, name, basename with more than one dot with powershell.

How to parse basename to first dot.

How to use PadLeft.

How to add leading and ending zeroes to strings with PowerShell.

Update zipfiles with PowerShell 5 or greater. gci, get-childitem, regex, regular expression, regular expressions, $Matches, foreach, the current item from the pipe, $_, PadLeft, Compress-Archive, and Remove-Item. Average 29 milliseconds on 9 files (48KB) in 3 archives on ten runs.


Solution

  • Using Group-Object to compress files for each group is a bit faster.

    pushd $env:USERPROFILE\Desktop
    
    ni @(
        "1.1.txt"
        "1.txt"
        "11.txt"
        "2.1.3.6.txt"
        "2.1.txt"
        "2.txt"
    ) > $null
    
    gci *.txt | where BaseName -match "^(\d+)(\.\d+)*$" | group { $Matches[1] } | foreach {
        $dest = 'FileGroup' +  $_.Name.PadLeft(10, "0") + ".zip"
        Compress-Archive $_.Group $dest -Update -ea Stop
        ri $_.Group
    }
    
    Read-Host @" 
    Delete all FileGroup*.zip is next.
    Press enterkey to delete all test files.
    "@
    
    ri FileGroup*.zip
    popd