Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find & Replace in Multi-Megabyte Strings
This is a re-post of "Batch Replace function for Large strings"
String processing in VBA is very slow when strings are large (1-500 MB). I have a function that I've been using for doing batch replace ops (in the above referenced previous post), but it chokes on large strings with many replacements to do (like 50), because it has to do 50 passes of the string to perform the replacements. Has anyone written a fast function designed to do the same thing for large strings but only makes one pass through the data? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
How to find a value with multi-column, multi-record list | Excel Worksheet Functions | |||
How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
Using a collection class to implement mutliple find/replace strings in cells | Excel Programming |