upper to proper case in brackets

Discussion created by pierrek on Oct 30, 2011
Latest reply on Nov 7, 2011 by pierrek
Hi there,

I have a name field in the database in capital letters. To label them in proper cases I use a label expression 'upper to proper case' no worries. :)

But when it comes to a name within brackets it does not work any more.

E.g. name in field: WARRAL (HAWKESBURY) ISLAND -> Warral (hawkesbury) Island.

Any idea how to fix that middle name?

Thanks a lot.