Hi,
i am working on a project where I have to read a .txt file for a feed and parse the data line by line.

I am using FSO in ASP to do this and it is working fine on small versions of the file, unfortunatly, the actual file is massive in size (670,000 kb) and I am not able to interprete the full file.

There is about 200,000 lines in the file of up to 4,000 characters each and i can read the first thousands fine but the problem starts when going further.

Due to the size of the file, I am unable to store it in a variable or array etc to manipulate it, the best way I have found is by looping through the lines and reading them one by one.
I can think of 2 solutions here, I could read a line and then remove it, do this for let say 1000 lines, move out of the file (which is now smaller by 1000 lines) and reaccess it and do the same again. The problem here is that I can't find a way to replace the line, is this possible to do??
I can write a line but it is a new line, it doesn't replace an existing one.

The second idea would be to loop through a number of line, for instance 1000, but only starting starting at line 1001 for instance, this way i could access the file several times. The only way I have found to do this is by using SkipLine but it means I still have to start the loop from the first line and ultimately, it ends crashing the same way.
Is there a way to start at loop at line???

Any pointer would be appreciated.

Why not just read the line from one file, do your processing, and then write the line to another file? After you are done, you can save the new file over the old file.

Ax

Hi,
i am not sure I am following you on this. If i overwrite the existing file without going to the end of it then I am loosing the data?

Sorry for the delayed response, but no, that's not what I'm talking about. Maybe this will help:

1. While there are still lines to process in the file
   1. Read the line from the existing file
   2. Perform necessary processing tasks
   3. Write the line to a new file
2. Repeat
3. After all lines have been processed and then saved to the new file, save the new file as the original file if necessary; or just use the new file for whatever you need it

Ax