[AccessD] A2003: Extracting strings

Marty,

Thank you for all great information.

Steve Erbach

On 11/18/05, MartyConnelly <martyconnelly at shaw.ca> wrote:
>
> It has been available since vbscript.dll came out. There were three
> version (5.0 or 1.0) 5.5 and 5.6
> 5.6 has a lot of additional methods to handle multi-line regexp, some
> may have been OS specific.
>
> With Access 97 you had force a VBA reference in code with a specific
> entry points to old versions of the dll.
>
> After 5.6 came out you could just do CreateObject("vbscript.regexp")
> I think I cheesed off some Swedish programmer who was selling a mda
> solution for $50
> when I posted the method on comp.databases.ms-access about 5 years ago.
> .
> I have a sample mdb at
> http://www.rogersaccesslibrary.com/OtherLibraries.asp
> look under my name for RegularExpressionValidator. It is just code I was
> using for testing.
>
>
> The most useful part is the regexp pattern documentor, I borrowed the
> VB6 code from Don Edwards Seattle.
> in frmRegExTester. Handy for looking at long paragraph length patterns.
> I have seen one for emails
> that is 4 pages long.
>
> "\d{1,2}[-]+\d{1,2}[-]+\d{1,4}"
>
>
> digit 1 to 2 times
> Followed by any of - one or more times
> Followed by digit 1 to 2 times
> Followed by any of - one or more times
> Followed by digit 1 to 4 times
>
>