Find & Replace in Multi-Megabyte Strings
Cool! The RegEx (early bound) in my tests is 4-5x faster than VBA's
replace. However, I think that this might even be able to be improved
more... I think it should be possible to do all of the find/replaces
in a single pass of the string, further improving the speed by a factor
of however many replaces there are to do.
Since doing 6 search and replaces requires calling the Regex replace
function 6 times, it is iterating over the string 6 times, but it
should really only need to do it once.
Perhaps some sort of clever regex could combine all of the
search/replace ops into a single call of .Replace.
Or perhaps a custom procedure would be better... i'll make a post
if/when i find the answer i'm looking for.
Thanks for the idea! And for now, i'll take the 5x improvement ;D
|