- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 27, 2023 03:22 PM
Hi,
I'm trying to validate customer's mails, to send them automated mails.
I created a column validating another Email column in my relevant table, but the formula shows me that the mail doesn't match the regex, even though I know it's a working mail.
the formula is:
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 28, 2023 05:56 AM
Their example has a typo in it, which you should report to Airtable using the thumbs down button at the bottom of the article.
Here is the working formula:
REGEX_MATCH( {Email address}, "(\W|^)[\w.\\-]{0,25}@[A-Za-z0-9.-]+\\.[A-Za-z]{2,}(\W|$)")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 27, 2023 06:44 PM
That doesn't look like the regex in the support page you cite. It also doesn't look like an Airtable RE2 regex pattern because it ends in /g.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 27, 2023 09:40 PM
You are right. it was another Regex I tried.
tried also the one in the link, still didn't work("(\W|^)[\w.\\-]{0,25}@[A-Za-z0-9.-]+\\.[A-Za-z]{2,}(\W|$)")
This is the example that appears in the link:
REGEX\_MATCH( {Email address}, "(\W|^)[\w.\\-]{0,25}@[A-Za-z0-9.-]+\\.[A-Za-z]{2,}(\W|$)")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 28, 2023 05:56 AM
Their example has a typo in it, which you should report to Airtable using the thumbs down button at the bottom of the article.
Here is the working formula:
REGEX_MATCH( {Email address}, "(\W|^)[\w.\\-]{0,25}@[A-Za-z0-9.-]+\\.[A-Za-z]{2,}(\W|$)")
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 28, 2023 06:10 AM
Still doesn't work. 😕

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 28, 2023 06:13 AM
It works just fine for me.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 28, 2023 06:58 PM
What is your field type? Is it a lookup field? If so, you will need to convert it to a text string.
Can you include screen shots?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 29, 2023 12:33 AM
Thank you guys!
It worked. Found other typoes in my formula, and after implementing the formula @ScottWorld sent, it worked perfectly.
