topic Re: First letter upper in Management & Governance

First letter upper

zied_ahmed1 — Fri, 10 Aug 2018 09:11:23 GMT

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

Re: First letter upper

dsharmaqv — Fri, 10 Aug 2018 09:22:03 GMT

try this

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

Re: First letter upper

arvind1494 — Fri, 10 Aug 2018 09:25:45 GMT

Use this:

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

Re: First letter upper

zied_ahmed1 — Fri, 10 Aug 2018 09:29:29 GMT

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

DEEpak sharma...

Re: First letter upper

zied_ahmed1 — Fri, 10 Aug 2018 09:29:48 GMT

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

Re: First letter upper

zied_ahmed1 — Fri, 10 Aug 2018 09:33:02 GMT

it works thank you

Re: First letter upper

rubenmarin — Fri, 10 Aug 2018 09:34:17 GMT

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

Re: First letter upper

arvind1494 — Fri, 10 Aug 2018 09:50:40 GMT

Welcome