william liang via AccessMonster.com wrote:
If not, what is the Expression in Access which has the same functionality?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
There is no RegExp parser in Access, nor in JET - besides the LIKE
parsers.
You might want to use the VBS RegExp object (or whatever it is) by
creating a Reference to it in the VBA Tools > References. I'm not
familiar w/ VBS, but I do know there is a RegExp parser in there. IOW,
you could use the VBS RegExp parser in a VBA function. Call the
function from the query that is reading the table w/ the email address.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQm1x4YechKqOuFEgEQIh8QCghilPm64MCJUVV41krv04jv OAIPgAn10l
tn2C6eoAFLX/s5qGR1frTOBu
=tW36
-----END PGP SIGNATURE-----