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

      Hello

       

      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.