Regular Expression in Oracle with REGEXP_SUBSTR
I want to get the email address part of a string. For example if the
string is
"your name(your@name.com)" aaa@bbb.com
then I want to get only
aaaa@bbb.com
basically if I can remove the string within
"
then it does the trick. I am using below regular expression with
REGEXP_SUBSTR
REGEXP_SUBSTR('"your name(abc@dd.com)"
aaa@bbb.com','([a-zA-Z0-9_.\-])+@(([a-zA-Z0-9-])+[.])+([a-zA-Z0-9]{2,4})+')
kindly help.
No comments:
Post a Comment