topic Proper Case in QlikView

Proper Case

gerhardl — Tue, 28 Jun 2011 11:19:17 GMT

Hi,

Is there something like the excel Proper function I can use in QV?

I have fields where our system shows all stores in UPPERCASE, I want to change them all to Proper Case. I've played around with the Force statement but this seems to be for Field Names, I just want to change the field values.

Like I would use the number function...

Regards,

Gerhard

Re: Proper Case

Tue, 28 Jun 2011 11:25:18 GMT

I think you are looking for the capitalize() funtion. Used just like lower() or upper().

Proper Case

kaushiknsolanki — Tue, 28 Jun 2011 11:28:26 GMT

Hi,

Try Capitalize() to achieve this.

Here is an example

capitalize ( 'my little pony' )

returns 'My Little Pony'

capitalize ( 'AA bb cC Dd' )

returns 'Aa Bb Cc Dd'

Regards,

Kaushik Solanki

Re: Proper Case

richardwilde — Wed, 19 Feb 2025 20:31:11 GMT

What would be better at times is a function that doesn't mess with the capitalization of inner letters, but just changes the first letter of each word to be capital - otherwise you get acronyms now in lower case after the first letter which isn't what I want.