Regular Expressions Access Query

[Aubreylc]

I've been trying to figure out how to use regular expressions in an Access Query. So far I can validate the string but I cannot figure out how to return the strings value into another field. Does anyone have any suggestions? Attached is the sample database.

 

[jdraw]

see
http://timothychenallen.blogspot.com/2006/05/ms-access-vba-regular-expressions-regex.html

http://bricestacey.com/blog/2010/07/regular-expressions-ms-access

 

[Aubreylc]

Perfecto!!.....Thank you!