Openplatform.xyz Follow @openplatformxyz

PowerShell Scripts

 Feb 12, 2021

 

# List files in a folder

Get-ChildItem "C:\temp"

# List all text files in a folder recursively (include subfolders)

Get-ChildItem "C:\temp\*.txt" -recurse

# What does $_ mean in PowerShell?

This is the variable for the current value in the pipe line, which is called $PSItem in Powershell 3 and newer. For example in the below code the %{} block is called for every value in the array. The $_ or $PSItem variable will contain the current value.

1,2,3 | ForEach-Object {Write-Host $_}

% is alias for ForEach-Object so above code can be written as below

1,2,3 | % {Write-Host $_}

# Remove lines starting with "--" from multiple files

Get-ChildItem "C:\Program Files\xMS\LogFiles\DailyLogs\*.xme" -recurse | ForEach{(Get-Content $_ | Where { $_ -notmatch "^--" }) | Set-Content $_}

# Remove lines starting with "Rec" from multiple files

Get-ChildItem "C:\Program Files\xMS\LogFiles\DailyLogs\*.xme" -recurse | ForEach{(Get-Content $_ | Where { $_ -notmatch "^Rec" }) | Set-Content $_}

# Insert a line at top of multiple files

$header = "Received,Occurred,Closed,Location,Element,Severity,Source,Type,Status,Ack,Seq. #,User,Equipment Type"

Get-ChildItem "C:\Program Files\xMS\LogFiles\DailyLogs\" -Recurse -Filter *.xme| Foreach-Object { @($header;Get-Content $_.FullName) | Set-Content -Path $_.FullName}

For big files, following is a faster way to insert header at top of multiple files

$header = "Received,Occurred,Closed,Location,Element,Severity,Source,Type,Status,Ack,Seq. #,User,Equipment Type"

$files = Get-Childitem "C:\Users\shariramani\Desktop\delete\xme\*.csv"

foreach ($file in $files)
{
$header | Set-Content tempfile.txt
Get-Content $file -ReadCount 5000 |
Add-Content tempfile.txt
Remove-item $file
Rename-Item tempfile.txt -NewName $file
}

# Apend a string or line to all text files with an exception

This code appends a line to all text files in the specified directory but excludes files based on their file name.

Add-Content -Path "C:\temp\*.txt" -Exclude help* -Value 'End of file'

Append a line using variable

$myline="End of File"

Add-Content -Path "C:\temp\*.txt" -Exclude help* -Value $myline

# Remove empty lines

Get-ChildItem "C:\Program Files\xMS\LogFiles\DailyLogs\*.xme" -recurse | ForEach{(Get-Content $_ | Where {$_.trim() -ne "" }) | Set-Content $_}

# Replace TAB with comma

Get-ChildItem "C:\Program Files\xMS\LogFiles\DailyLogs\*.xme" -recurse | ForEach{(Get-Content $_ | ForEach {$_ -replace "`t", “,”}) | Set-Content $_}

# Rename multiple files

This code renames file extension from filename.xme to filename.csv

Get-ChildItem "C:\Program Files\xMS\LogFiles\DailyLogs\*.xme" | Rename-Item -NewName { $_.name -Replace '\.xme$','.csv' }

# Windows Powershell Script to Delete Files Created Before X days

$HowOld = 45 #Path to the folder where script will look and delete older files #Note script will also look in all subfolders $Path1 = "C:\Program Files\xMS\tmp\backup" $Path2 = "C:\Program Files\xMS\tmp\reports" $Logfile = "C:\Program Files\xMS\tmp\cleanup_$(gc env:computername).log" function WriteLog { Param ([string]$LogString) # $LogFile = "C:\$(gc env:computername).log" $DateTime = "[{0:MM/dd/yy} {0:HH:mm:ss}]" -f (Get-Date) $LogMessage = "$Datetime $LogString"a Add-content $Logfile -value $LogMessage }a # Defines the 'x days old' (today's date minus x) $age = (Get-Date).AddDays(-$HowOld) # Get all the files in the folder and subfolders | foreach file Get-ChildItem $Path1,$Path2 -Recurse -File | foreach{ # if creationtime is 'le' (less or equal) than x days if ($_.CreationTime -le $age){ WriteLog "Remove: Older than $HowOld days - $($_.fullname)" # remove the item (suffix -whatif to just check and no action done) Remove-Item $_.fullname -Force -Verbose }else{ Write-Output "Less than $HowOld days old - $($_.fullname)" # Do stuff } }