Re: String Parsing : Best Methods : VBA
- From: "Tom Ogilvy" <twogilvy@xxxxxxx>
- Date: Mon, 23 Jan 2006 09:25:28 -0500
Possibly by using regular expressions
http://support.microsoft.com/default.aspx?scid=kb;en-us;818802&Product=vbb
HOW TO: Use Regular Expressions in Microsoft Visual Basic 6.0
--
Regards,
Tom Ogilvy
"vmegha" <vmegha@xxxxxxxx> wrote in message
news:1138024167.518078.318160@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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
>
.
- References:
- String Parsing : Best Methods : VBA
- From: vmegha
- String Parsing : Best Methods : VBA
- Prev by Date: Re: Output list based on value in a cell
- Next by Date: Re: Playing a WAV file in Excel 2002
- Previous by thread: String Parsing : Best Methods : VBA
- Next by thread: Re: How to: assign a value to a cell without selecting the cell first
- Index(es):
Relevant Pages
|
