Re: Need to exit loop early

Thanks again for your reply. What you have suggested is basically what I am
doing - but it's quite a long script, and it's getting really complicated.
There may be about 3 or 4 separate conditions where I want to "exit" the loop.

"Björn Holmgren" wrote:

> Sorry, I completely misread your question. I thought you wanted to exit the
> loop, not skip the rest of the code and continue looping.
>
> In this case, the best you can do is enclose the code you might want to skip
> in an IF...END IF clause. Something like this:
>
> Do Until objTextFile.AtEndOfStream
> ' some code that may generate an error
> If Err.Number = 0 Then
> ' code to execute if no error was generated
> End If
> ' read next line
> Loop
>
>
> --
> Björn Holmgren
>
>
> "Jo Winchester" <JoWinchester@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:83958553-8D11-4117-ABE0-A4146BBDA9B1@xxxxxxxxxxxxxxxx
> > I have just tested this with a small sample script - and it does exit the
> "do
> > loop". However, it exits it completely - what I need is the the loop to
> > continue looping through all records.
> >
> > "Björn Holmgren" wrote:
> >
> > > "Jo Winchester" <JoWinchester@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message
> > > news:B11167CF-A33E-4400-8A42-9FB42B6DABAA@xxxxxxxxxxxxxxxx
> > > > Hopefully this is a straight forward question.
> > > >
> > > > I have a script that reads a file one line at a time, and carries out
> > > > ceratin actions depending on what it reads on each line. The script
> uses
> > > a
> > > > Do Until....Loop, using
> > > >
> > > > Do Until objTextFile.AtEndOfStream
> > > >
> > > > Loop
> > > >
> > > > I need to add error checking, so that if a set action to be carried
> out by
> > > > the script has an err.number <> 0, the loop will ignore the rest of
> the
> > > loop,
> > > > and continue to the next line of the text file that it is reading.
> So,
> > > what
> > > > I need to the command to end one "loop" early, but continue through
> > > remaining
> > > > loops. I'm sure it should be really simple, but I don't seem to be
> able
> > > to
> > > > get the syntax right.
> > >
> > > Exit Do
> > >
> > > --
> > > Björn Holmgren
> > >
> > >
> > >
> > >
>
>
>
.

Relevant Pages

  • Re: Errors when reading a file in Bourne shell -- HELP
    ... I am trying to exit out of the ... the do while and not the shell itself. ... whole shell script. ... to 1 and checking it after the loop. ...
    (comp.unix.questions)
  • Re: trying to understand fork and wait
    ... old habits based on learning to script in REXX on the ... > the child reads it. ... situation for me (drop through to bottom/go back to top of loop). ... just to keep a hold of the exit code. ...
    (comp.lang.perl.misc)
  • Re: problem with exit while using nohup
    ... as it is evident, the exit should cause the script to terminate,hence ... outside the loop but does not exit the program. ... My guess is that you're using different shells in the two cases. ...
    (comp.unix.shell)
  • Re: How do I properly use global variables?
    ... I'd like my program below to change $status to zero to exit the loop. ... When script is running,how can you re-run it with another argument to ... When you run it,you can send SIGINT or SIGTERM to let it exit gracefully. ...
    (perl.beginners)
  • Re: How to copy an appointment from the public folder to the local
    ... and it's still looping. ... program runs the script. ... > that loops what you showed does not loop. ... > Reminder Manager, Extended Reminders, Attachment Options ...
    (microsoft.public.office.developer.outlook.vba)