Change Case from Lower to Upper for First Letter of Name

saileshsorde-fruzjqhn · 2012-10-04T07:59:00.000Z

Hi Guru’s, Please help me to change first letter of name from lower case to upper case? for example, a) if user enters ‘kelly brooke’ then it should be stored as ‘Kelly Brooke’ b) if user enters ‘kelly_brooke’ then it should be stored as ‘Kelly_Brooke’ c) if user enters ‘kelly.brooke’ then it should be stored as ‘Kelly.Brooke’ d) if user enters ‘KELLY BROOKE’ then it should be stored as ‘Kelly Brooke’ I am using Siebel 8.1and IE 6.0 Regards, Sai

nareshlalam-mwcyujjp · 2012-10-07T13:58:00.000Z

Hi Sai,

In your case, you need to write custom script to achieve your requirement.

Siebel treats the complete value (Kelly.brooke) as a single string value and if you use “FIRSTUPPER”, it converts only the first “k” to “K”.
In your case, you need to extract the sub strings of the complete name, as individual names and convert them to Init Caps and next join/merge them to a complete string value.

Regards,
Naresh.

previoustoolboxuser · 2012-10-04T08:18:00.000Z

Use Business Component field property Force Case . Supported values are UPPER,LOWER and FIRSTUPPER.