How to Delete leading zeros

[Anonymous]

Requirement is to delete fields starting with zeros and make it as NULL. Also keep NULL for alpha-numeric values.

Old Field	New Field
00123	Null
345	345
045	Null
0000563	Null
6589	6589
3457	3457
asdd	Null
fgfdg	Null

[Anonymous]

perhaps like that?:

LOAD * where not wildmatch([Current Field],'0*');

LOAD * INLINE [

    Current Field

    00123

    345

    045

    0000563

    5644

];

[MarcoWedel]

‌If(not [Old Field] like '0*', [Old Field]) as [New Field]

regards

Marco

[Siva_Sankar]

Hi Kirubakaran,

Find the attached example.

following script checks if the column begins with zero and it checks whether it is alphanumeric, if yes then returns Null,else the values.

Load *,

if(left([Old Field],1)=0 or isnum([Old Field])=0 ,'Null',num([Old Field])) as [New Field];

LOAD [Old Field]

FROM

[https://community.qlik.com/thread/263073]

(html, codepage is 1252, embedded labels, table is @1);

-Siva

[Anonymous]

Hi

Please find attached application.

Hope it helps!!