Hi, when you have a 'double barrel' name (Mr Smith-Jones) is there a way of ensuring that the J of Jones stays uppercase? In the data all surnames are uppercase so I am having to use "proper" for the Salutation, however for double-barrel names this then creates Mr Smith-jones.

Drewie,
In PrintShop Mail, the PROPER function only capitalizes the first character of each word.

http://help.objectiflune.com/en/printshop-mail-user-guide/Default_CSH.html#/465.html



In the below example, "hyphenated-name" is the field with hyphenated names.


PROPER(MID([hyphenated-name], 0, POS([hyphenated-name], "-", 1))) & PROPER(MID([hyphenated-name], (POS([hyphenated-name], "-", 1))+1,LEN([hyphenated-name])))


Please change as apporpriate and advise of results.

You could also consider upgrading to version 7. The PROPER function in PSM7 will capitalize the J of Jones "properly".

Edit: PROPER in PSM7 also correctly handles other cases like "McDonald", "A&B", and "O'Reilly".

Thanks Jeff_K your suggestion works a treat!Drewie

In the Western tradition of surnames, there are several types of double surname (also double-barrelled surname). If the two names are joined with a hyphen, it may also be called a hyphenated surname.




Water Conditioner Cinnaminson NJ