View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vmegha vmegha is offline
external usenet poster
 
Posts: 13
Default String Parsing : Best Methods : VBA

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