I need to extract the domain from the email field ...
# suiteanalyticsp
pen one
10/27/2021, 5:35 PMI need to extract the domain from the email field and was using the below formula but this gives me the text before the @. How can I get the domain instead:
SUBSTR({email}, 1, (INSTR({email}, '@',1)-1))g
Gregory Jones
10/27/2021, 6:02 PMsubstr({email},instr({email},'@')+1)