Double barrel names

Posted by: Drewie

Double barrel names - 02/19/13 03:16 AM

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.
Posted by: Anonymous

Re: Double barrel names - 02/19/13 07:57 AM

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

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.
Posted by: Sander vd Berg

Re: Double barrel names - 02/19/13 08:00 AM

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".
Posted by: Drewie

Re: Double barrel names - 02/19/13 08:47 AM

Thanks Jeff_K your suggestion works a treat!Drewie
Posted by: Alici Asilver

Re: Double barrel names - 11/17/16 11:43 PM

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