String Parsing : Best Methods : VBA

V

vmegha

Hi,

Anybody, with any advice / suggestions on what is the best methods
/practices on parsing strings. I have a really huge string, that
provides a major performance Bottleneck while reading through. Right
now I split it by a delimiter, fill it into a Variant and run through
each (shorter length) string within the Variant, and use Instr , Mid$
and Right$ while parsing out a Key, Value Pair. Any ideas, any
articles?

Thanks in Advance,
Regards,
Megha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best way to format a flat file that Excel will load properly? 8
How to Parse a string; Delimiter is any Operator 27
Moving VBA6 string functions into VBA5 4
Best/Easiest way to search/find in a string 13
parsing and importing a text file with records through a VBA macro 2
load/parse large text file 10
Parsing a string to retrieve numerals 2
macro to select range from active cell range name string 2

Top