Forum Discussion

MindaMay's avatar
MindaMay
Qrew Cadet
6 years ago

Formula field that extracts the domain name from an email address

I'm trying to create a formula field that extracts the domain name from an email address. For example, for no-reply@accounts.domainname.com I would want to see domainname.com. For soandso@domainname.c...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
np,
I'm still getting used to he new world of the domain name flexibilities.

I tested this and it seem to work


var text DotEnding = "." & Right([From], ".");
var text Domain = Right(NotRight([From],"."),"@.");

$Domain & $DotEnding