Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Display String into excel from program as mentioned below...

Former Member

‎2011 Jun 02 6:08 AM

0 Likes
374

Hi,

I am downloading excel from report program.

I can convert string to either uppercase or lowercase,but i need to convert the string like this as shown below,,,,

'SUBRHMANYAM' conver this name into

'Subrahmanyam'.

The first letter should be capital.

2 REPLIES 2
Read only

Former Member

‎2011 Jun 02 6:25 AM

0 Likes
338

You can use FUNCTION : 'ISP_CONVERT_FIRSTCHARS_TOUPPER'

Read only

Former Member

‎2011 Jun 02 7:08 AM

0 Likes
338

Hi,

You can try this.

va_text = 'subrahmanyam'.

TRANSLATE va_text+0(1) TO UPPER CASE.