Formula to extract email domain

[Dora_Salinas]

I’d like to strip the domain from the email address. It can be done with RIGHT, LEN, and FIND in Excel but I’m having trouble translating it to Airtable. Can anyone help?

[Kamille_Parks]

More string handling functions Product Suggestions

@Alex_Armstrong and @nnnnneil You could use a combination of RIGHT(), LEN() and FIND() RIGHT({Email Field},LEN({Email Field})-FIND('@',{Email Field}))

[Gary_Stark]

[quote=“Kamille_Parks, post:2, topic:21188”]
RIGHT(), LEN() and FIND() RIGHT({Email Field},LEN({Email Field})-FIND(’@’,{Email Field}))

Hi Kamille! Can you let me know why I’m getting an error message when I use this formula to extract the domain name? My column containing the e-mail address is called, “e-Mail”.

[Gary_Stark]

FYI…my image didn’t show that I did put an “=” before the formula and it still didn’t work :slightly_smiling_face:

[Gary_Stark]

Kamille_Parks:

RIGHT({Email Field},LEN({Email Field})-FIND(’@’,{Email Field}))

Duh…I think I added more than I needed to the formula, but it’s still not working. Here’s what I have now (attachment).

[Kamille_Parks]

Get rid of the equal sign at the beginning. Although its necessary for Excel and Sheets, you don’t put an = before a formula in Airtable.

You also have an extra } at the end of all your field names. The name of your fields should be preceded by one { and followed by one }.

[Gary_Stark]

Gary_Stark:

RIGHT({Email Field},LEN({Email Field})-FIND(’@’,{Email Field}))

That did it…YOU ROCK!! Also, in the interim I found this formula that worked as well…MID({e-Mail},SEARCH("@",{e-Mail})+1,255).

The 255 is just to be sure you capture long domains. THANK YOU!!

[David_Meyers]

Has anyone crafted a similar formula to extract the domain from a website URL?

[Kamille_Parks]

LEFT(SUBSTITUTE(SUBSTITUTE({field name}, "https://", ""), "http://", ""), FIND("/", SUBSTITUTE(SUBSTITUTE({field name}, "https://", ""), "http://", ""))-1)

^ What that’s doing: remove http:// or https:// from the url, then get all the text up until the first backslash.

[David_Meyers]

Kamille: That’s fantastic. But I tried it:

LEFT(SUBSTITUTE(SUBSTITUTE({Org Website}, “https://”, “”), “http://”, “”), FIND("/", SUBSTITUTE(SUBSTITUTE({Org Website}, “https://”, “”), “http://”, “”))-1)

Airtable accepted the formula, but returns an error in each cell where the calculation runs. Any ideas?