will REGEXP_SUBSTR work in MS Access?

[william liang via AccessMonster.com]

If not, what is the Expression in Access which has the same functionality?

--
Message posted via http://www.accessmonster.com

[MGFoster]

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-----