Proper Case

[gerhardl]

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

[#2 · Accepted solution]

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

[kaushiknsolanki]

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

[richardwilde]

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.