To get domain name from an email address using saved search

A formula(text) can be selected in the column field and
SUBSTR({email}, INSTR({email}, ‘@’) + 1, INSTR({email}, ‘.’) – INSTR({email}, ‘@’) – 1)
can be entered in the formula field.

For example:
If the email address is “test@gmail.com”
By using the above-mentioned formula in saved search, we get “gmail” from the saved search results.

Leave a comment

Your email address will not be published. Required fields are marked *