Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to remove the first five 0 from the data.
TAB1:
LOAD * INLINE
[
CUSTOMER
0000012234,
00000REPLW,
1236050
];
Plz help me out.
Thanks.
Hi,
Try like below,
TAB1:
LOAD *, If(Left(CUSTOMER,5)='00000',Mid(CUSTOMER,6),CUSTOMER) as New;
LOAD * INLINE
[
CUSTOMER
0000012234,
00000REPLW,
1236050
];
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;
check there : https://community.qlik.com/thread/2804