pdiprint Posted September 24, 2009 Share Posted September 24, 2009 I am trying to create a salutation (Dear First Name). Sometimes the first name field only has initials and the middle name is what should be used. In all cases the middle name field is empty unless there are initials. Can you please help with a script. Link to comment Share on other sites More sharing options...
esmith Posted September 24, 2009 Share Posted September 24, 2009 If the middle name field only has content when the first name contains initials, then you should be able to just use the following: return (Field("MIDDLE_NAME") == "") ? Field("FIRST_NAME") : FIELD("MIDDLE_NAME"); Link to comment Share on other sites More sharing options...
pdiprint Posted September 24, 2009 Author Share Posted September 24, 2009 Thank you, that worked. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.