Thread: Return string to the right of a given character

Hi --

I have a list of e-mail addresses, and need to extract just the domains, that is, everything after the "@" character. I've tried a bunch of things and haven't been able to account for the fact that the string length will be variable.

Here are some data examples with the result I need:

abc @si.idemitsu.co.jp = si.idemitsu.co.jp
abc @ic.ac.uk = ic.ac.uk
abc @plusorthopedics.com = plusorthopedics.com
abc @unsw.edu.au = unsw.edu.au
abc @psu.edu = psu.edu
abc @dpyus.jnj.com = dpyus.jnj.com
abc @sous.com* = sous.com

Any advice?

Thanks very much


*pls ignore the spaces before the @ symbols -- just trying to keep the site from turning these into active links.