jamesearth
New Member
- Joined
- Jul 14, 2010
- Messages
- 3
Hey everyone,
Just registered for the forum - seems like an incredible community resource!
Anyhow, I did a little searching and found a few threads on VBA imports from text files to excel, but I had a slightly more specific request.
I have a text file that is very large (almost 1GB - over 3m rows), and I want to extract less than 50k rows from it.
The rows I want can be identified by a value in column 4 - 'CreationDate', if 2010-05-01 =< CreationDate =< 2010-06-01 , I want to extract that row to an excel file.
The VBA file doesn't necessarily need to run quickly - I can leave it running on my computer overnight, etc.
Are there easy-to-implement frameworks out there that would do this efficiently? I'm on a Mac right now, but could probably move to a PC, too.
Thanks!
Just registered for the forum - seems like an incredible community resource!
Anyhow, I did a little searching and found a few threads on VBA imports from text files to excel, but I had a slightly more specific request.
I have a text file that is very large (almost 1GB - over 3m rows), and I want to extract less than 50k rows from it.
The rows I want can be identified by a value in column 4 - 'CreationDate', if 2010-05-01 =< CreationDate =< 2010-06-01 , I want to extract that row to an excel file.
The VBA file doesn't necessarily need to run quickly - I can leave it running on my computer overnight, etc.
Are there easy-to-implement frameworks out there that would do this efficiently? I'm on a Mac right now, but could probably move to a PC, too.
Thanks!