working with very large text files

[Anil]

hi all,

maybe you can give me a hand with the following.

I used the following examples http://www.cpearson.com/excel/imptext.htm to import a textfile into a worksheet, do some calculations with it and export the result into another textfile.

Now I get into trouble when the original file is too large (over 65000 lines), since excel will not be able to handle that.

What I would like to do is import the first bunch of lines (lets say 50.000), do the calculations and export the result to result.txt. Then import the next set of 50.000 lines, do the calculations and append the result to result.txt, etc. until I have processed the complete input file.

Any tips/solutions ?

Many thanks.

 

[hianupam]

I have run into this problem myself and have used Perl to import parts of the file into an excel spreadsheet.