Extract domain name from columns with e-mail address

[Laurent Willen]

Hello,

 

I'm trying to isolate domain names from a list of e-mail addresses I have in Spotfire.

 

Some examples:

test@gmail.com should become gmail

test@hotmail.be should become hotmail

test@mycompany.test.comshould become mycompany.test

 

I'm using the following:

RXExtract(lower([booker Email]),"(

[Khushboo Rabadia]

You can try below if it works for all scenarios:

left(RXExtract(lower([Emailid]),"([a-z0-9.{0,1}]+)\.",1),Len(RXExtract(lower([Emailid]),"([a-z0-9.{0,1}]+)\.",1)) - 1)