Leading zeroes AND upper case

[PSM]

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

to

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

[sunny_talwar]

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

[trdandamudi · Accepted solution]

One way is as below:

Data:

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

[PSM]

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

[trdandamudi]

You are welcome...