How to caplialize the first letter

[#1]

Hi All,

I would like to capitalize the first letter even there exists underline or blank like this

cq1_test aaa to Cq1_Test Aaa

How can I do it?

Thanks.

[amit_saini]

Isaac,

Try This:

     upper(left(trim(data),1)) & lower(mid(trim(data),2,len(data)))

where data is the field containing the text you wish to change.

Thanks,
AS

[Anonymous]

Hi Isaac,

Try the function Capitalize:

capitalize(s )

Returns the string s with all words capitalized.

Example:

capitalize ('my little pony') returns 'My Little Pony'

capitalize ( 'AA bb cC Dd') returns 'Aa Bb Cc Dd'

Regards,

[sujeetsingh]

Upper(Left(Field,1))& Right(Field,len(Field)-1)

[aveeeeeee7en]

Try This Expression:

=upper(left(String,1))&mid(String,2,len(String)-9)
&upper(left(Subfield(Left(String, index(String, ' ', 1)-1) ,'_',2),1))&mid(Subfield(Left(String, index(String, ' ', 1)-1) ,'_',2),2,len(Subfield(Left(String, index(String, ' ', 1)-1) ,'_',2))-1)&' '&upper(left(SubField(String,' ',2),1))&mid(SubField(String,' ',2),2,len(SubField(String,' ',2))-1)

Kindly, replace String with your FieldName.

Also, see the Attachment.

Hope that helps.

Regards

Aviral Nag