Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <# sample command line
- .\sanitizeLinkfixerScans.ps1 -SourcePath "G:\Shared drives\LinkFixer Scans\" -fileFilter "Scan Detail*" -OFilePrefix "sanitized-"
- #assign params from command line
- #>
- param(
- [Alias("UNCPath")]
- [Parameter(Mandatory)]
- [string]$SourcePath, #trailing backslash is required
- [Parameter(Mandatory)]
- [string]$fileFilter,
- [Alias("OFilePrefix")]
- [Parameter(Mandatory)]
- [string]$OutputFilePrefix
- )
- $sanitizeFiles = (Get-ChildItem -Path $SourcePath -Filter $fileFilter).Name #.Name does not include the SourcePath
- $mycountdown = $sanitizeFiles.count
- if ($mycountdown -eq 0) {
- Write-Host "exiting, no files matching '$fileFilter' in '$SourcePath'" -ForegroundColor Green -backgroundColor DarkGray
- exit
- }
- else {
- $begTime = Get-Date
- #$begTime
- $myCounter=0
- foreach ($csvFile in $sanitizeFiles) {
- $myCounter++
- $fullFileName = $SourcePath + $csvFile
- $textToReplace = [System.IO.File]::ReadAllText("$fullFileName") #read the file once
- <#The .Replace() method, when used directly on a string object, is case-sensitive.
- #-Replace regex: starts with "Computer Name:..." ends with "Log Time" so a blank line is not left at the top.
- This also ensures 1 replacement which is at the beginning of the file where "Log Time" appears (row 5).
- #>
- $textToReplace = $textToReplace -replace '(?s)\"Computer Name:.*?\"Log Time','"Log Time'
- $textToReplace = $textToReplace.Replace('LinkTek Support via phone (727-442-1822) or email ([email protected])', 'support')
- $textToReplace = $textToReplace.Replace('LinkTek Support via email at [email protected] or call 727-442-1822', 'support')
- $textToReplace = $textToReplace.Replace('Support via email at [email protected] or call 727-442-1822', 'support')
- $textToReplace = $textToReplace.Replace('LinkTek Support', 'support')
- $textToReplace = $textToReplace.Replace('LinkTek support', 'support')
- $textToReplace = $textToReplace.Replace('help at 727-442-1822', 'support')
- $textToReplace = $textToReplace.Replace('LinkFixer Advanced', 'analysis')
- $oFile = $SourcePath + $OutputFilePrefix + $csvFile
- [System.IO.File]::WriteAllText($oFile, $textToReplace)
- Write-Host $csvFile "($myCounter of $myCountdown)"
- }
- $endTime = Get-Date
- #$endTime
- New-TimeSpan -Start $begTime -End $endTime | Select-Object -Property TotalSeconds
- Write-Host "end of script: $myCounter of $myCountdown sanitized" -ForegroundColor Green -backgroundColor DarkGray
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
