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.
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?
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: