Powershell - multiple commands to multiple files

Question

Hoping someone can help me finish off this script. I have a folder full of *.imp (plain text - csv exports) files that I need to modify. These files are updated on a schedule, so this Powershell script will be updated on a schedule too, but I can't seem to get it to work.

Here is where I've gotten so far...

$InputFiles = Get-Item "C:\scripts\*.imp"
$OldString  = '@##'
$NewString  = '"'
$InputFiles | ForEach {
(Get-Content -Path $_.FullName).Replace($OldString,$NewString) | Set-Content -Path $_.FullName
(Get-Content -Path $_.FullName).-notmatch '(^[\s,-]*$)|(rows\s*affected)' | Set-Content -Path $_.FullName
(Get-Content -Path $_.FullName).-notmatch 'HeaderRow' | Set-Content -Path $_.FullName
}

If I leave the first Get-Content line, it works, but adding the other two don't. Can anyway help me with this? Thanks Luke

Remove the dot from .-notmatch (replace with space)

Lieven Keersmaekers
– Lieven Keersmaekers

2018-03-02 06:17:59 +00:00
Commented Mar 2, 2018 at 6:17 — Lieven Keersmaekers
– Lieven Keersmaekers, Commented Mar 2, 2018 at 6:17

Mathias R. Jessen · Accepted Answer · 2018-03-02 08:57:04Z

2

As Lieven points out you need to remove the . reference operator in the second and third statement:

$InputFiles = Get-Item "C:\scripts\*.imp"
$OldString  = '@##'
$NewString  = '"'
$InputFiles | ForEach {
  (Get-Content -Path $_.FullName).Replace($OldString,$NewString) | Set-Content -Path $_.FullName
  (Get-Content -Path $_.FullName) -notmatch '(^[\s,-]*$)|(rows\s*affected)' | Set-Content -Path $_.FullName
  (Get-Content -Path $_.FullName) -notmatch 'HeaderRow' | Set-Content -Path $_.FullName
}

Instead of reading and writing the file from disk three times, you could chain all the operations:

$InputFiles = Get-Item "C:\scripts\*.imp"
$OldString  = '@##'
$NewString  = '"'
$InputFiles | ForEach {
  (Get-Content -Path $_.FullName).Replace($OldString,$NewString) -notmatch '(^[\s,-]*$)|(rows\s*affected)' -notmatch 'HeaderRow' | Set-Content -Path $_.FullName
}

answered Mar 2, 2018 at 8:57

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

1 Comment

ValiantSirDK Over a year ago

Thanks Lieven and Mathias. I used the tidier version you supplied Mathias, and it works wonders. Thank you for your gracious help!

Collectives™ on Stack Overflow

Powershell - multiple commands to multiple files

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related