Re: fastest way to change case of string

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"RB Smissaert" <bartsmissaert@xxxxxxxxxxxxxxxx> wrote
I agree it always will be a problem, but it still should handle it
gracefully.
I think your function gives an error and Larry's gets stuck in an endless
loop.

Add one line of code to my routine:

Following: posB = InStr(posA + 1, Text, QUOTE, vbBinaryCompare)
Add: If posB = 0 Then Exit Do

Viola, a graceful ending!

<g>
LFS


.

Relevant Pages

  • Re: need some help with I/O
    ... >> I will work on a graceful way to exit the loop. ... Providing a graceful exit from the loop may greatly reduce the ... the fflush or change the buffering mode to line buffering. ...
    (comp.lang.c)
  • Most efficient way to transfer OdbcDataReader to sql server
    ... I havent seen anyway to transfer the data over to sql server in a graceful ... I have to generate sql statements dynamically or loop through each ... meaning I cant create a DSN. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: New trickes for me!!! How about you
    ... It's more like what Kaori does, only a lot less graceful and just one of ... What Ryan Woessner does at the end of his routine appears to be ...
    (rec.sport.unicycling)
  • Re: need some help with I/O
    ... "Les Coover" wrote: ... > I will work on a graceful way to exit the loop. ...
    (comp.lang.c)
  • Re: Efficient select/insert
    ... Subject: Efficient select/insert ... That's graceful. ... So to loop through ~150 tiny rows is probably no hardship ...
    (perl.dbi.users)