topic Re: Adding Zero's in QlikView

Adding Zero's

Vinod — Wed, 21 Nov 2018 04:57:32 GMT

Hi All,

How to add Zero's in between characters and Numbers,

Please find the attachment for your reference.

Thanks

Vinod,

Re: Adding Zero's

tresB — Wed, 21 Nov 2018 05:33:10 GMT

In script or UI?

Re: Adding Zero's

Vinod — Wed, 21 Nov 2018 06:27:08 GMT

In Script Only

Re: Adding Zero's

tresB — Wed, 21 Nov 2018 06:49:18 GMT

Temp:
Load *,
Mid(Vin_No,1,FindOneOf(Vin_No, '0123456789')+1) as NumPart

Inline [
Vin_No
MBJ123
MBJ1234
MBJ12345
];
Load
Max(Len(NumPart)) as MaxNum
Resident Temp;
Let vNumLength = Peek('MaxNum');
Let vNumFormat = chr(39)& Repeat('0',vNumLength) & chr(39) ;
Final:
Load
Vin_No,
Mid(Vin_No,1,FindOneOf(Vin_No, '0123456789')-1) & Num(KeepChar(Vin_No, '0123456789'), $(vNumFormat)) as Formatted_Vin_No
Resident Temp;
DROP table Temp

Try something like above.

Re: Adding Zero's

avinashelite — Wed, 21 Nov 2018 07:00:48 GMT

If it always starts with MBJ* Try like this

left(Vin_No,3)&0&keepchar(Vin_No,'0123456789') as Test

Re: Adding Zero's

Vinod — Wed, 21 Nov 2018 07:17:28 GMT

Thank You, It's working.

Re: Adding Zero's

tresB — Wed, 21 Nov 2018 07:31:48 GMT

In this new community it is hard to find whom you replied to. Which solution is working for you, the static one Avinash suggested or the one I suggested? Please like (it's important now 🙂 ), mark helpful/correct the posts you feel so and close the thread.

Re: Adding Zero's

avinashelite — Wed, 21 Nov 2018 09:09:24 GMT

Hi Vinod , could you please like the solution which helped you to resolve the issue ...with the new community site we don't have any ways to mark the thread as answered ..