-
1. Re: Calculation to find only domain in email address
pooja.gandhi Aug 4, 2014 7:25 AM (in response to Brandon Avants)2 of 2 people found this helpfulOpen the filter box of you measure or dimension and use the 'wildcard tab' and fill in the required info.
-
2. Re: Calculation to find only domain in email address
Brandon Avants Aug 4, 2014 7:31 AM (in response to pooja.gandhi)That would be nice but there are other company names I need to look for. I want to use email address to be able to find the company names because that's my only option.
-
3. Re: Calculation to find only domain in email address
Toby ErksonAug 4, 2014 8:07 AM (in response to Brandon Avants)
2 of 2 people found this helpfulI did it in two parts but you could mash it all into one.
First calculated field:
(Copy/paste this)
MID([Email],FIND([Email],"@" )+1 ) //Get everything after the @
Final calculated field:
(Copy/paste this)
LEFT([Full_Domain],FIND([Full_Domain],"." ) -1 )
Thus Domain_Name is the field you want to use.
-
4. Re: Calculation to find only domain in email address
Shawn Wallwork Aug 4, 2014 8:12 AM (in response to Toby Erkson)Toby beat me to it. But since I worked it out, I'll post the other way of doing it (just for variety):
Trim Dot Com
LEFT( [Email],FIND([Email],'.',FIND([Email],'@') )-1)
Everything after @
RIGHT([Trim Dot Com],LEN([Trim Dot Com])-FIND([Trim Dot Com],'@'))
--Shawn
Toby: And I thought you were sticking with Server questions (of the non-mind-reading type).
-
5. Re: Calculation to find only domain in email address
Toby ErksonAug 4, 2014 8:16 AM (in response to Shawn Wallwork)
shawnwallwork wrote:
Toby: And I thought you were sticking with Server questions (of the non-mind-reading type).
Hehehehe For the Tableau Alerts Alerter I was working on I played quite a bit with the FIND and REPLACE string functions so this was a no-brainer for me.
-
6. Re: Calculation to find only domain in email address
Brandon Avants Aug 4, 2014 8:24 AM (in response to Shawn Wallwork)Toby,
Thank you sooooo much this works PERFECTLY!!!!! You're my new best friend.