how to remove first five zero from column field value

[suhascool1]

i have table which is look like this so how to remove 0 digti from the column field value.

code	manager
0000033433	Alok
0000033564	Master
0000033555	Snehal
0000033545	Rahul

final result look like this

code	manager
33433	Alok
33564	Master
33555	Snehal
33545	Rahul

[Bhaskarkumar · Accepted solution]

LOAD code,
num(num#(code)) as Code ,
manager
FROM
[https://community.qlik.com/t5/App-Development/how-to-remove-first-five-zero-from-column-field-value/...]
(html, utf8, UserAgent is 'Mozilla/5.0', embedded labels, table is @1);

[henrikalmen]

Try this: num#(code)

[Frédéricdh]

I find you can use a stringfunction: like

Right see:

Right - Skript- und Diagrammfunktion | QlikView Hilfe

Or Textbetween:

TextBetween - Skript- und Diagrammfunktion | QlikView Hilfe

[henrikalmen · Accepted solution]

I would not recommend using Right() or TextBetween(), especially not if
not all values have the same number of leading zeros. The num#()
function should be used. If the resulting value should be text, one can
wrap it like this: text(num#())

[suhascool1]

thanks