[AccessD] Find characters in one string that are in another: was RE: Treat string as array

Hi Charlotte

When you write here you are very precise, so I guess your coding is exactly to the point. He just tries to provoke you.

/gustav

>>> cfoust at infostatsystems.com 26-03-2008 16:42:31 >>>
And pigs will fly any day now!  I lost that war years ago.  He sees my
code as "over-complicated".

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael Bahr
Sent: Tuesday, March 25, 2008 8:36 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Find characters in one string that are in
another: was RE: Treat string as array

Hi Charlotte, instr only returns a positive value if the string part is
found and is rather static in looking for a string.  Regex's are dynamic
in looking for strings and its derivatives plus it returns a boolean if
the pattern is matched--at this point we do not care about the string
position.  Perhaps you can convince your boss that you want to take
things to the next level so you can be more productive.  :-)

Mike...

> Yep, I love em.  My boss prefers InStr as more "readable", so I don't 
> get to use them very often ... Even in dot net. :-<
>
> Charlotte Foust