Powershell: where depending on exit code from command without temp variable

Question

I'm trying to limit a pipeline output to those elements where a certain command's exit code is 0.

$myData | where { $temp = sqlcmd -i Checker.sql -v DATA=$_; $LASTEXITCODE -eq 0 }

Checker.sql raises an error if the data doesn't pass the check.

Is there a way to tell PowerShell to ignore the output of sqlcmd without putting it into a temp variable? If I don't include the $temp =, I just get back my original data set. Thanks!

MrKWatkins · Accepted Answer · 2012-03-06 14:48:44Z

3

You could pipe the output to Out-Null:

$myData | where { sqlcmd -i Checker.sql -v DATA=$_ | Out-Null; $LASTEXITCODE -eq 0 }

answered Mar 6, 2012 at 14:48

MrKWatkins

2,6791 gold badge21 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Powershell: where depending on exit code from command without temp variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related