Re: Function to read text file; find string; delete same before import
- From: EagleOne@xxxxxxxxxxxxxxxxxxxxxxxxx
- Date: Sat, 02 Aug 2008 11:00:59 -0400
In reality, the files have gone to 25MB; average about 8MB.
All of the solutions have their place. In advance of my posting, I did do Google Searches - both
the Add in and straight through. I was surprised that I did find much directly
applicable/easily-adaptable to either Excel and/or Access.
All of the responses are excellent for this forum to synergyze OPs on this issue. Thanks to all for
your time and knowledge.
"Rick Rothstein \(MVP - VB\)" <rick.newsNO.SPAM@xxxxxxxxxxxxxxxxxx> wrote:
.I remember having trouble with VBA's Replace for longgggggg strings--and
since
the OP said that there were over 65k lines of data, I wonder if VBA's
replace
would work in this case.
Based on the sample data the OP posted, I estimate his data file is around 2
to 2.5 Megs in size... that should not be too large for the Replace function
to be able to do its "thing" with. Maybe if the file were around 15 to 20
Megs or more, I would be reluctant to recommend the solution I posted, but I
feel it will work comfortably with files up to 10 Megs without any problems.
Rick
- Follow-Ups:
- Re: Function to read text file; find string; delete same before import
- From: Rick Rothstein \(MVP - VB\)
- Re: Function to read text file; find string; delete same before import
- References:
- Function to read text file; find string; delete same before import
- From: EagleOne
- RE: Function to read text file; find string; delete same before import
- From: Joel
- Re: Function to read text file; find string; delete same before import
- From: EagleOne
- Re: Function to read text file; find string; delete same before import
- From: Rick Rothstein \(MVP - VB\)
- Re: Function to read text file; find string; delete same before import
- From: Dave Peterson
- Re: Function to read text file; find string; delete same before import
- From: Rick Rothstein \(MVP - VB\)
- Function to read text file; find string; delete same before import
- Prev by Date: Re: Function to read text file; find string; delete same before import
- Next by Date: Re: Extract top 5 elements from table
- Previous by thread: Re: Function to read text file; find string; delete same before import
- Next by thread: Re: Function to read text file; find string; delete same before import
- Index(es):
Relevant Pages
|
