topic Re: Leading zeroes AND upper case in QlikView

Leading zeroes AND upper case

PSM — Tue, 20 Aug 2019 16:09:02 GMT

Hi all

I have a product file creating me a lot of problems as it has both leading zeroes I need to keep and a mixture of lower and upper case letters that should all be upper case.

Having tried the below I get problems in how it treats the different codes and never get good data.

I want to turn

3230

03230

a123456

A456123

bB987654

3230 no change

03230 keep zero

A123456 capitalise

A456123 no change

BB987654 capitalise

I have tried Upper(Text("product.code")) as "product.code"

Thanks for help

Re: Leading zeroes AND upper case

sunny_talwar — Tue, 20 Aug 2019 16:56:56 GMT

So, what is the issue that you are running into?

Re: Leading zeroes AND upper case

trdandamudi — Tue, 20 Aug 2019 17:43:51 GMT

One way is as below:

Data:

Load Text(Upper(Data_Value)) as data Inline
[
Data_Value
3230
03230
a123456
A456123
bB987654
];

Re: Leading zeroes AND upper case

PSM — Wed, 21 Aug 2019 09:02:14 GMT

Thank you so much. Simplest solution I could not see !

Re: Leading zeroes AND upper case

trdandamudi — Wed, 21 Aug 2019 10:41:06 GMT

You are welcome...