Advertisement
Guest User

Untitled

a guest
May 21st, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Get-ChildItem -Path .\Generated |   #Get each file in the folder
  2.     ForEach-Object {                #Creates a loop to apply to each file in folder found by Get-ChildItem
  3.         $inputFile = $_.Name        #Establish variable for the next line
  4.         $outputFile = $inputFile -replace '.*2018-', 'Filtered_' -replace '.........\.csv', '.csv' #rename file
  5.         Import-Csv $_.FullName |    #Import CSV file by filename
  6.             Select * -ExcludeProperty "Size on Disk", "Size", "Owner" |         #Only select wanted columns
  7.                 Where-Object{$_.Filename -notlike "{*}{*}"} |                   #Remove filename junk
  8.                 Where-Object{$_.Filename -notlike "VM_*"} |                     #Remove filename junk - voicemails
  9.                 Where-Object{$_.Filename -notlike "*.tmp"} |                    #Remove filename junk - temp files
  10.                 Where-Object{$_.Filename -notlike "*.css"} |                    #Remove filename junk - css files
  11.                 Where-Object{$_.Filename -notlike "*.gif"} |                    #Remove filename junk - gif files
  12.                 Where-Object{$_.Filename -notlike "*.download"} |               #Remove filename junk - download files
  13.                 Where-Object{$_.Filename -notlike "*.ini"} |                    #Remove filename junk - .ini files
  14.                 Where-Object{$_.Folder -notlike "*\AppData\*"} |                #Remove folder junk - AppData
  15.                 Where-Object{$_.Folder -notlike "*\IntelGraphicsProfiles"} |    #Remove folder junk - IntelGraphicsProfiles
  16.                 Where-Object{$_.Folder -notlike "*\xTools\*"} |                 #Remove folder junk - xTools
  17.                 Where-Object{$_.Folder -notlike "*RECYCLE.BIN*"} |              #Remove folder junk - Recycling Bin  
  18.         Export-Csv .\Filtered\$outputFile -NoTypeInformation                    #Output to a new CSV file
  19. #       Write-Host $outputFile                                      #Used for testing output
  20.     }   #close foreach-object loop
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement