After searching here I have successfully created formulas to manipulate an email field and now I want to know if those formulas can be combined so I only need one extra field.
I get email addresses like this …
and I want to end up with JUST the domain and with the “student” and “students” part stripped out (e.g. acc.edu.au, or frsa,asn.au
I can end up with the domain by using this …
RIGHT(email, SUM(LEN(email), -FIND("@", email)))
And I can get rid of the “student” and “students” by using this …
Is there anyway of joining these two so that I only have one field? I tried the “&” but I just end up with two domains.
Many thanks! And thanks to those who post here so that I was even able to get this far.