topic How to remove 0 from script. in QlikView

How to remove 0 from script.

lalitkgehlot89 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to remove the first five 0 from the data.

TAB1:

LOAD * INLINE

[

CUSTOMER

0000012234,

00000REPLW,

1236050

];

Plz help me out.

Thanks.

tamilarasu — Wed, 16 Mar 2016 10:03:11 GMT

Hi,

Try like below,

TAB1:

LOAD *, If(Left(CUSTOMER,5)='00000',Mid(CUSTOMER,6),CUSTOMER) as New;
LOAD * INLINE
[
CUSTOMER
0000012234,
00000REPLW,
1236050
];

avinashelite — Wed, 16 Mar 2016 17:37:21 GMT

if you have 5 zeros always then ...try like this

TAB1:

LOAD * INLINE

[

CUSTOMER

0000012234,

00000REPLW,

1236050

];

result:

LOAD if(left(CUSTOMER,5)='00000',replace(left(CUSTOMER,5),'',CUSTOMER) as New_CUSTOMER,

CUSTOMER

resident

TAB1;

Drop table TAB1;

pascal_theurot — Tue, 03 Jul 2018 13:56:26 GMT