Powershell loop through multiple files

Question

I'm trying to loop through multiple files to see if a job completed. I'm very new to powershell and am trying to understand the basics of how looping works before creating a more detailed program. I can't figure out what's wrong in my code. When I run the program no output ("Success" or "Fail") is displayed. Any suggestions on looping through sql directory files to search for a specific string appreciated too:)

Get-ChildItem "C:\Users\afila\Desktop\TEST" -Filter "*.txt" |
ForEach-Object{
if(Object.Contains("*Loaded successfully*"))
{
    Write-Host "Success" 
}
else
{
    Write-Host "Fail"
}

}

Tchotchke · Accepted Answer · 2017-08-07 22:33:17Z

1

Use $_ where you have Object.Contains. It should read "$_.Contains".

Since you are using wildcards in your IF statement, you may also try -like. -like, by default, treats the search with wildcards:

Get-ChildItem "C:\Users\afila\Desktop\TEST" -Filter "*.txt" |
ForEach-Object{
if($_ -like "Loaded successfully")
{
    Write-Host "Success" 
}
else
{
    Write-Host "Fail"
}

answered Aug 7, 2017 at 22:33

Tchotchke

3991 gold badge4 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Maximilian Burszley Over a year ago

The entire purpose of -like is wildcard operations, so there is no other behavior.

Tchotchke Over a year ago

That's what I said? "-Like treats the search with wildcards".

Jason Snell · Accepted Answer · 2017-08-07 21:49:50Z

0

When using the pipeline you have to use $_ to represent the object passed down the pipeline. For example

Get-ChildItem C:\temp\ -Filter "txt" | 

Foreach-Object{
    if($_.Contains("my test info"))
    {
       write-host "success"
    }
}

The $_ is similar to the word "this" in other languages and is just a representation of the current object.

answered Aug 7, 2017 at 21:49

Jason Snell

1,46512 silver badges22 bronze badges

1 Comment

Maximilian Burszley Over a year ago

It's nothing like this because that construct already exists within PowerShell.

Collectives™ on Stack Overflow

Powershell loop through multiple files

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related