topic Re: capitalize in QlikView

capitalize

Thu, 29 Sep 2011 10:51:59 GMT

Hi,

Any suggestions how you can present your data in a list box with the first position of the string as an upper-case and the rest of the string as lower case?

For example: in data: john, john-T ,

in list box: John, John-t

/Anders

capitalize

rohit214 — Thu, 29 Sep 2011 11:34:36 GMT

hey buddy

use

=capitalize('john, john-T')

thanks

rohit

Re: capitalize

its_anandrjs — Thu, 29 Sep 2011 11:39:05 GMT

Hi,

See the attached sample file.

Rgds

Anand

capitalize

SunilChauhan — Thu, 29 Sep 2011 11:42:20 GMT

try this

=Upper(left(Fieldname,1)) &lower(mid(Fieldname,2,len(Fieldname)-1))

capitalize

Thu, 29 Sep 2011 12:00:04 GMT

Works

Thanks

Re: capitalize

rohit214 — Thu, 29 Sep 2011 12:48:16 GMT

hi,

use the expression shown in below.you will get exatly what you want in your answer

=Upper(left(FieldName,1))& lower(mid(FieldName,2,4)) &Upper(left(FieldName,1)) & lower(mid(FieldName,2,4)) &'-'& lower(right(FieldName,1))

thanks

rohit

Re: capitalize

its_anandrjs — Thu, 29 Sep 2011 13:00:14 GMT

Hi,

Without the use of Upper only use with Capitalize

Capitalize(ColA)

If data is correct ise capitalize it will faster also.

See attached file.

Rgds

Anand

Re: capitalize

Thu, 29 Sep 2011 13:05:26 GMT

Hi,

Thanks, but capitalize will transform john-T to John-T. The T will still be an upper case.

/Anders

Re: capitalize

its_anandrjs — Thu, 29 Sep 2011 13:11:41 GMT

Hi,

Now see the attached

by using

By this

=Capitalize( Left ( ColA,len(ColA)-1))&lower(Right(ColA,1))

you get the desire out put that you want John, John-t

Rgds

Annad

Re: capitalize

its_anandrjs — Thu, 29 Sep 2011 13:29:23 GMT

Hi,

Can you check your result now it is correct or not.

Rgds

Anand