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

    String function in Script

    Isabel Nowinowski

      Hello,

       

      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)

       

      Thanks,

      Isabel