String Parsing : Best Methods : VBA

  • Thread starter Thread starter vmegha
  • Start date Start date
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
 
Back
Top