topic Re: how to remove first five zero from column field value in App Development

how to remove first five zero from column field value

suhascool1 — Thu, 22 Feb 2024 07:34:14 GMT

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

Re: how to remove first five zero from column field value

Bhaskarkumar — Thu, 22 Feb 2024 07:56:56 GMT

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/td-p/2422061]
(html, utf8, UserAgent is 'Mozilla/5.0', embedded labels, table is @1);

Re: how to remove first five zero from column field value

henrikalmen — Thu, 22 Feb 2024 07:57:04 GMT

Try this: num#(code)

Re: how to remove first five zero from column field value

Frédéricdh — Thu, 22 Feb 2024 08:04:05 GMT

I find you can use a stringfunction: like

Right see:

Right - Skript- und Diagrammfunktion | QlikView Hilfe

Or Textbetween:

TextBetween - Skript- und Diagrammfunktion | QlikView Hilfe

Re: how to remove first five zero from column field value

henrikalmen — Thu, 22 Feb 2024 08:15:50 GMT

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#())

Re: how to remove first five zero from column field value

suhascool1 — Thu, 22 Feb 2024 16:54:04 GMT

thanks