+7Hi,
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:
Best answer by ScottWorld
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|$)")
+29That 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.
+7That 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.
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|$)")
+35Their 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|$)")
+35It works just fine for me.
+29What 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?
+7Thank you guys!
It worked. Found other typoes in my formula, and after implementing the formula @ScottWorld sent, it worked perfectly.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.