Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
One way is as below:
Data:
Load Text(Upper(Data_Value)) as data Inline
[
Data_Value
3230
03230
a123456
A456123
bB987654
];
So, what is the issue that you are running into?
One way is as below:
Data:
Load Text(Upper(Data_Value)) as data Inline
[
Data_Value
3230
03230
a123456
A456123
bB987654
];
Thank you so much. Simplest solution I could not see !
You are welcome...