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.