Has anyone written a token script that will return only part of a data field? I use our Salesperson token often, which will return their full name. I would like to make it a little more personal by only returning the first name. I've tried scripts to split the data in the field, returning only what it before the first space in the field, but have had no luck. I'm not a developer, nor do I have one at my disposal--so my knowledge of how to use what I find on the Internet is limited. Please let me know if anyone has accomplished this.
Right now I have:
#set ($name = ${lead.Salesperson})
#set ($repfullname = $name.split(" "))
$repfullname[0]
Returns: $repfullname[0]