Error with foreachloop within foreachloop Powershell

Question

I have written script with the purpose of filtering different jobs which I ripped from a server based on the '@command=N'

$orginal_submap = 'C:\Users\Desktop\Jobs_from_Server\Jobs_Orgineel_opdr_2.3'

$orginal_rejected = 'C:\Users\Desktop\Jobs_from_Server\Jobs_Orgineel_opdr_2.3\gefaald'

$fileserver = Get-ChildItem $orginal_submap *.sql 

$stringfile = '@command=N''/FILE*'

$stringisserver = '@command=N''/ISSERVER*'

$commandline = '@command=N'

$startloop = 1 

foreach ($fileser in $fileserver)

{

$currentline = Select-String $fileser -pattern $commandline  

#countss how often the @command is containded in the file
$numberoftimesloopd = $currentline.length

do 

    { 
    if ($startloop -gt $numberoftimesloopd) {break}  
    foreach ($commandline in $currentline)

        { 
        $startloop

        if ($commandline -match $stringfile) {'@command=N''/FILE'}

        elseif ($commandline -match $stringisserver) {'@command=N''/ISSERVER'}

        else  {'gefaald'}

        #if the amount of loops is equel to the number of '@command=N' it stops the loop
        $startloop++ 
        if ($startloop -gt $numberoftimesloopd) {break}
    }

} while ($startloop-le  $numberoftimesloopd)

einde

}

My problem is that instead of quitting after running a job or simply gets the next *sql file from the source map it gives an error namely

It says that the error is in $currentline = Select-String $fileser -pattern $commandline

Problem is I have looked multiple times and try different things like adding start loop to stop the program to try keep running the script.

Can someone help solve the error and ensure that the script will quit if all files are done and if not take the next job from the source.

Or help me pinpoint the source of the problem/possible solution

paul543 · Accepted Answer · 2016-10-12 13:58:34Z

1

In the following line you should use -SimpleMatch parameter so Select-String does not interpret the value of the Pattern parameter as a regular expression statement:

$currentline = Select-String $fileser -pattern $commandline -SimpleMatch

answered Oct 12, 2016 at 13:58

paul543

1784 silver badges17 bronze badges

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

1 Comment

Jarno343 Over a year ago

Thanks for the tip the code still doesnot loop troug all files and only reads the first. But the error is gone and that is certanily a imporvement.

Collectives™ on Stack Overflow

Error with foreachloop within foreachloop Powershell

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