Do until ... loop not working

[Imran J Khan]

I am trying to build a routine which reads a text file and parses and deletes
data from it, untill there is not data left in the text file. However, my
loop continues to run past when the text file is "" and I need it to stop
when the file is "".
I assign the contents of the file to the variable strText which is declared
at the option explicit section before any of the subs/functions.

I have the following code for the loop
Do until strText = ""
'does various things
Loop

Have I misunderstood how this is supposed to work.

If I change the the code as below
Do until not (strText = "")

This works if I make the change during debugging, but exits the loop without
extracting data because the strText is not empty.
I am chasing my on tail again. Help.

 

[orange via AccessMonster.com]

I am trying to build a routine which reads a text file and parses and deletes
data from it, untill there is not data left in the text file. However, my
loop continues to run past when the text file is "" and I need it to stop
when the file is "".
I assign the contents of the file to the variable strText which is declared
at the option explicit section before any of the subs/functions.

I have the following code for the loop
Do until strText = ""
'does various things
Loop

Have I misunderstood how this is supposed to work.

If I change the the code as below
Do until not (strText = "")

This works if I make the change during debugging, but exits the loop without
extracting data because the strText is not empty.
I am chasing my on tail again. Help.

I think you're going to have to show us some more vba code in order for
someone to understand what it is you're trying to do.

If you are not resetting the value of strText in your Do Loop, it will never
change.

You could put the text into a temporary table and process that table, but
until we understand your problem we're only guessing.

 

[Daryl S]

Imran -

Should you be testing for end of file (.EOF) instead of an empty string? Is
this set up as a recordset? Do you have a 'MoveNext' in there? We don't
have enough information to help you...