Topic Options
#42355 - 02/19/13 03:16 AM Double barrel names
Drewie Offline
OL Newbie

Registered: 06/04/10
Posts: 8
Loc: Worcester. UK
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.

Top
#42361 - 02/19/13 07:57 AM Re: Double barrel names [Re: Drewie]
Jeff_K
Unregistered


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.

Top
#42362 - 02/19/13 08:00 AM Re: Double barrel names [Re: ]
Sander vd Berg Offline
OL Expert

Registered: 06/10/08
Posts: 197
Loc: Objectif Lune NL
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".


Edited by Sander vd Berg (02/19/13 08:12 AM)

Top
#42363 - 02/19/13 08:47 AM Re: Double barrel names [Re: ]
Drewie Offline
OL Newbie

Registered: 06/04/10
Posts: 8
Loc: Worcester. UK
Thanks Jeff_K your suggestion works a treat!Drewie

Top
#54232 - 11/17/16 11:43 PM Re: Double barrel names [Re: Drewie]
Alici Asilver Offline
OL Newbie

Registered: 11/17/16
Posts: 1
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

Top