Split domain from email address

[OKCMikeSoll]

Hi Everyone -

I have seen posts related to my issue but was unable to "reverse" the logic to fix my issue.

I am trying to strip the domain name from an email address.

Current:
my.name@mycompany.com

Want to return:
mycompany.com

The current formula I have is as follows:
ToText (Trim(Split({TABLE.EMAIL}, "@")[1]) )

This returns everything before the @ sign. How can I reverse this logic? If this is answered in another post I apologize. Please redirect me. Thanks in advance.

Thanks,
Mike

CR2008
XCELSISUS 2008
ORACLE 9i

 

[IdoMillet]

Try

Split({TABLE.EMAIL}, "@")[2]

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com