This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
or see the attached file
View solution in original post
How you use that function please see the sample
Capitalize ( 'my little pony' ) = My Little Pony
Let me know about this.
Its ues like this:
Capitalize(Firstname) as Firstname
Then all firstnames will come out with capital letter.
See the attached sample file.
Can you provide any sample file.
I'm using the function capitalize correctly because all words come out capitalized.
I want the string to come out as this:
My little pony
Only capital M
How can i do this?
That is exactly what i'm looking for.
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: