I have a merge field which outputs a users full name as:

John Doe

I'd like to only output:



J Doe

Is this at all possible? I realise this is no perfect solution as the user may well have a first, middle and last name but happy to just split off the abbreviation for the users first name and the rest of the name appear as normal.

Any help would be greatly appreciated.