working with very large text files

Anil

New Member
Joined
Aug 23, 2002
Messages
3
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.
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

hianupam

New Member
Joined
Mar 28, 2002
Messages
37
I have run into this problem myself and have used Perl to import parts of the file into an excel spreadsheet.
 

Forum statistics

Threads
1,143,743
Messages
5,720,601
Members
422,292
Latest member
Bernd0501

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top