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

String Parsing : Best Methods : VBA
 

Possibly by using regular expressions

http://support.microsoft.com/default...02&Product=vbb
HOW TO: Use Regular Expressions in Microsoft Visual Basic 6.0

--
Regards,
Tom Ogilvy



"vmegha" wrote in message
oups.com...
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