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:



      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?