Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think you are looking for the capitalize() funtion. Used just like lower() or upper().
I think you are looking for the capitalize() funtion. Used just like lower() or upper().
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