There are thread on this forum about the same and I tried those solution, but somehow they are not working. How do I validate an email with a single quote in them?
For example:
jonathan_o'brien@first.com
o'hara@two.com
steve.o'malley@three.com
d'arcy.talley@four.com
I am using the following regexp and it fails to recognize the single quote validation
REGEXP_LIKE (email, '^[_a-z0-9--’]+(\.[_a-z0-9--’]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$' )
Anyhelp would be appreciated.
Thanks