00:00Let's say you have a collection of email address like this here, which are fictitious by the way.
00:05How do you extract the domain name or the email domain name?
00:09No, no, let's make it more challenging.
00:11How do you extract a unique email domain name for the purpose of maybe email filtering and organizing?
00:17Or maybe data analytics and statistics and or for the purpose of security and fraudulent detection?
00:23Whatever the reason it is, here are the steps on how you can do it.
00:27The first thing to do is to extract the email domain name for all this email that you can do by using a function called text after.
00:35The first argument was text after would be the complete data set of email address.
00:40The second argument here would be the add symbol.
00:44So to get any text after the add.
00:46And if you hit enter here, it would create an array of all the domain name from every email here.
00:52But what we want is a unique.
00:53So what we're going to do is surround it, this text after function called by, a function called unique.
01:01Like this.
01:03And if you hit enter, you'll only get the unique email domain name address.
01:08Just like that.
Comments