Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Capitalize 1st letter of string

How can I capitalize only the first letter of a string?

With the capitalize function, all first letters of the words are capitalized, I only want the first wordt to be capitalized.

Regards

1 Solution

Accepted Solutions
TigerisBack
Champion
Champion

upper(left(Fieldname,1))&mid(Fieldname,2,len(Fieldname)-1)

or see the attached file

View solution in original post

8 Replies
its_anandrjs

Hi,

How you use that function please see the sample

Capitalize ( 'my little pony' ) =   My Little Pony

Let me know about this.

Rgds

Anand

Not applicable
Author

Its ues like this:

Capitalize(Firstname) as Firstname

Then all firstnames will come out with capital letter.

its_anandrjs

Hi,

See the attached sample file.

HTH

Rgds

Anand

its_anandrjs

Hi,

Can you provide any sample file.

Rgds

Anand

Not applicable
Author

I'm using the function capitalize correctly because all words come out capitalized.

BUT

I want the string to come out as this:

My little pony

Only capital M

How can i do this?

TigerisBack
Champion
Champion

upper(left(Fieldname,1))&mid(Fieldname,2,len(Fieldname)-1)

or see the attached file

View solution in original post

Not applicable
Author

That is exactly what i'm looking for.

Thanks!

Tyler_Waterfall
Employee
Employee

Thanks chauhans85 for this old post. Helped me today.

You can omit the last part of the mid() function to return the rest of the string:

upper(left(Fieldname,1))&mid(Fieldname,2))