Osiyuks · November 7, 2019 13:56
diff --git a/Email Validation in BigQuery b/Email Validation in BigQuery
 case
   when net.reg_domain(lower(email)) is null then false
   when regexp_contains(lower(email), "^[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])$") then true
   else false
 end
	case
	when net.reg_domain(lower(email)) is null then false
	when regexp_contains(lower(email), "^[a-z0-9!#$%&'+/=?^_`{\|}~-]+(?:\\.[a-z0-9!#$%&'+/=?^_`{\|}~-]+)@(?:[a-z0-9](?:[a-z0-9-][a-z0-9])?\\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])$") then true
	else false
	end
No results found