6 Replies Latest reply on Nov 5, 2018 12:48 PM by Stephen Brown

    String search to display a person's last and first initials

    Stephen Brown

      I have a field in the format :LASTNAME, FIRSTNAME.  I need to display the last and firstname initials.  The lastname I can do easily (LEFT([LASTNAME], 1).  But with the first name, how do I get to that.  I was thinking I could do a FIND(', ') >1, but how do I display the character immediately proceeding it.? Thanks.