By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,430 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

will REGEXP_SUBSTR work in MS Access?

P: n/a
If not, what is the Expression in Access which has the same functionality?

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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-----
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.