2 Replies Latest reply on Apr 6, 2012 9:56 PM by Xavier P

    Extract first name and last name from email address

    Xavier P



      I can extract a domain from an email address but not the first name and last name.


      Primarily because some email addresses might not have a dot and therefore a split between first name and last name.


      And also because some domains might have several dots e.g. virgin.co.uk


      What I need is a calculation where the email address below:


      joe.field@virgin.co.uk can be returned as:

      first name: joe

      last name: field


      and something like jfield@virgin.co.uk can be returned as:

      last name: field


      assuming the first letter is the initial.


      I don't think its tricky but could not figure it out.