3 Replies Latest reply: Aug 14, 2014 11:26 AM by Marco Wedel RSS

    String function in Script



      I want to apply a string function to the field [DM Name] to extract initials. For example, if the name is John Smith, I want JS.


      I have the following string function but how do I use this to create a new field with initials?


      left([DM Name], 1)


      left(subfield([DM Name], ' ', 2), 1)