Regex: Email validation

Regex: Validate email address

Explore this snippet here.

Description

The only real way to validate an email address is to send an email to it, but for the purposes of analytics it’s often useful to strip out rows including malformed email address.
Using the REGEXP_CONTAINS function, this example comes courtesy of Reddit user chrisgoddard:

1 Like