- Powershell
- Scripting Languages
- Microsoft Excel
- Microsoft Office
Poweshell Script to schedule
I have a folder named Error Log with thousands of txt files being logged by a third party application. Its difficult to find a specific error from those files and proactively fix related issues timely.
Can you help me with a powershell script which can search specific words from within those files in Error Log folder (e.g. '.' is missing or schema mismatch) and copy only those specific files to other folder named Status Errors?
I can then check Status Errors folder every evening and fix any errors so as to avoid any issues start of next day?
Can you help me with a powershell script which can search specific words from within those files in Error Log folder (e.g. '.' is missing or schema mismatch) and copy only those specific files to other folder named Status Errors?
I can then check Status Errors folder every evening and fix any errors so as to avoid any issues start of next day?
Something like this?
Edit:
On second thought, if you don't need the full power of regex, this is a bit easier to handle, as it generates the RegEx pattern on the fly, but it'll only search for literal strings.
$source = 'C:\Temp\Error Log\*.log'
$target = 'C:\Temp\Status Errors'
$pattern = "('\.' is missing)|(schema mismatch)"
Select-String -Path $source -Pattern $pattern | Copy-Item -Path $_.Path -Destination $target -Verbose -WhatIf
Edit:
On second thought, if you don't need the full power of regex, this is a bit easier to handle, as it generates the RegEx pattern on the fly, but it'll only search for literal strings.
$source = 'C:\Temp\Error Log\*.log'
$target = 'C:\Temp\Status Errors'
$strings = @(
"'.' is missing"
"schema mismatch"
)
$pattern = ($strings | ForEach-Object {"($([regex]::Escape($_)))"}) -join '|'
Select-String -Path $source -Pattern $pattern | Copy-Item -Path $_.Path -Destination $target -Verbose -WhatIf
That still needs a correction:
Select-String -Path $source -Pattern $pattern -List | Copy-Item -Path {$_.Path} -Destination $target -Verbose -WhatIf
or
https://chocolatey.org/packages/tailblazer
copy *.txt combined.log
https://chocolatey.org/packages/tailblazer
Explore More Content
Explore More ContentExplore courses, solutions, and other research materials related to this topic.
-
![]()
received a Solution
Powershell Script with Excel can't be launched from Windows Schedule Task -
![]()
wrote an Article
![]()
Useful Powershell script to resolve the X500 address
-
![]()
created a Video
![]()
[Webinar] How to Kill Browser Tabs and Tickets Using PowerShell - The Secret Sauce to SaaS
-
Explore Cloud Class® ![]()
Certification: MCSA MCSE Microsoft Certified Solutions Associate & Systems Engineer - Administering Windows Server 2012 R2
Premium Content
You need an Expert Office subscription to comment.Start Free Trial