2 Replies Latest reply: Oct 12, 2012 10:13 AM by Jen Starr RSS

    subfield used to breakout email address

    Jen Starr

      In the script I have the following:

       

      acc_email,

      subfield(acc_email,'.',2) as Domain,

      subfield(acc_email,'@',2) as Full_Domain,

       

      This works great as long as the email doesn't have another '.' before the @ such as Jane.Smith@gmail.com

       

      How can I get this to work regardless if there is an additional '.' before the @ or not?

       

      Thanks!

      Jen