Keep the newest file in each month and delete the rest

All replies

• 

  

  0

  Sign in to vote

  Where is the hash table?  What have you tried?  Post your script.

  ---

  \_(ツ)_/

  Monday, June 11, 2018 3:53 PM
• 

  

  0

  Sign in to vote

  The code below is based strictly on the format listed above for your hash table.  In the code, the hash table that would contain the file/date information is called $fileHashTable.  To note, if your dates do not include a time stamp you will not be able to accurately tell the difference between two files with the same date.  Hope this helps.

  $monthArray = @();
  $dateValues = $fileHashTable.Values;
  Foreach($date in $dateValues){
  	$date -match "^(\d{4}\-\d{2})\-\d{2}$" | Out-Null;
  	$month = $matches[1];
  	$monthArray += $month;
  }
  $uniqueMonthArray = $monthArray | Sort-Object -Unique;
  
  $valueOfFilesToRemove = @();
  $currentEntryArray = @();
  Foreach($monthEntry in $uniqueMonthArray){
  	$currentEntryArray = $dateValues | where {$_ -match $monthEntry};
  	$newestDate = ($currentEntryArray | Get-Date | Sort-Object -Descending)[0];
  	$valueOfFilesToRemove += $currentEntryArray | where {$_ -notmatch ($newestDate.GetDateTimeFormats())[5]};
  }
  
  $keys = $fileHashTable.Keys;
  Foreach($file in $keys){
  	$fileEntry = $fileHashTable[$file];
  	if($valueOfFilesToRemove -contains $fileEntry){
  		Write-Host "File to remove - $file";
  	}
  }
  

  
  

  Tuesday, June 12, 2018 3:49 AM
• 

  

  0

  Sign in to vote

  I have bot tested it, but this should do the trick:

  $groups = $Files.GetEnumerator() | group {$_.Value -replace "-\d{2}$"}
  foreach($g in $groups){
      $g.Group | sort Value -Descending | select -Skip 1 | foreach{Remove-Item $_.Key}
  }

  The data is grouped by year and month (which is the datekey without the last two digits and the minus before). Then, inside of each group files are sorted by date, the first one is skipped and the following ones are deleted.

  Tuesday, June 12, 2018 9:26 AM