CARLEENHOP
MIS
- Mar 7, 2010
- 61
Hi, I have a string eg. WK-WOVENS. I want it to appear on my report as WK-Wovens. If I change it to proper case it appears as Wk-Wovens, so i need to somehow tell it to leave everything before the '-' as uppercase and everything after as propercase. Does anyone know how? FYI - there are not always 2 characters prior to the '-' there can be only 1. Hence why I need the before/after '-' instead of saying after 2 characters.
Thanks
Carleen
Thanks
Carleen