How match email address with regex expression?

Question

the match to find email has wrong regex expression, leading to missing emails that should have been otherwise populated in the output.

Below is the query

case when regexp_like(email,'^([a-zA-Z0-9_\-\.]+)@([a-zA-Z0-9_\-\.]+)\.([a-zA-Z]{2,5})$')

The above regex expression doesn't match emails like BILL@AMERITRUST-MORTGAGE.COM Instead it returns null when such emails are encountered.

looks valid regex according to https://regex101.com/ which language you are trying it on? — Pritesh Kanthaliya, Jan 06 '21 at 13:01
please check an answer from https://stackoverflow.com/a/719543/7131875 — mkul, Jan 06 '21 at 14:52

score 1 · Accepted Answer · answered Jan 06 '21 at 13:09

1

I used this statement and it worked:

select 1
  from dual
 where regexp_like('BILL@AMERITRUST-MORTGAGE.COM', '^([a-zA-Z0-9_\.-]+)@([a-zA-Z0-9_\.-]+)\.([a-zA-Z]{2,5})$');

The minus character must be the last one in the [...].

answered Jan 06 '21 at 13:09

Kapitany

1 Answers1