First letter upper

[zied_ahmed1]

Hello,

I would like to capitalize the first letter of a field but to keep other words fixe

example :

alcDefG => AlcDefG

I tried Capitalize but there is not the requirement

Thanks

[dsharmaqv]

try this

https://community.qlikview.com/thread/36194

[arvind1494 · Accepted solution]

Use this:

Upper(left(Fieldname,1))&Mid(Fieldname,2,len(Fieldname)-1)

[zied_ahmed1]

I don't need to Capitalise every word : for Exemple if i have dEEpak sharma I need to have

DEEpak sharma...

[zied_ahmed1]

I tried this before posting my question but it doesn't work

[zied_ahmed1]

it works thank you

[rubenmarin]

Hi zied, Can you post a sample? that should work

It's directly saying: set first letter as uppercase and add other characters as they are. (3rd parameter for Mid is not really needed as you want all characters from the 2nd)

Edit: Ok

[arvind1494]

Welcome