Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How To Remove Leading Zeros in a Number


Hi All,

I have a field with the following values

00000978

00001524

00001024

00012356

The field is in number format.

The length of the field is constant and it is 8.

I would like to remove the leading zeros and would like to have the values as follows:

978

1524

1024

12356

Kindly help me to get the above output.

Thanks in Advance!!

Regards,

Vinitha.

7 Replies

Re: How To Remove Leading Zeros in a Number

Hi

Try like this

Num(Num#(FieldName,'#,##0'),'#,##0') AS FieldName;

or

Num(FieldName)

nagaiank
Valued Contributor III

Re: How To Remove Leading Zeros in a Number

Use the script below

LOAD *, Number8digit+0 As Number;
LOAD * Inline [
Number8digit
00000978
00001524
00001024
00012356
]
;

Capture.PNG.png

Re: How To Remove Leading Zeros in a Number

Load

  NUMBER,

  Num(NUMBER) as NUMBER1,

  NUM(Right(NUMBER, Len(NUMBER)-FindOneOf(NUMBER, '123456789')+1)) as NUMBER2

Inline

[

  NUMBER

  00000978

  00001524

  00001024

  00012356

];

Re: How To Remove Leading Zeros in a Number

Hi,

You can try below code.

LOAD *,

replace(ltrim(replace(Number, '0', ' ')), ' ', 0) as New_Number;

LOAD * Inline [

Number

00000978

00001524

00001024

00012356

];

Regards

ASHFAQ

Re: How To Remove Leading Zeros in a Number

Num(YourField)


should be the easiest way.

Not applicable

Re: How To Remove Leading Zeros in a Number

Hi Vinitha

you can perform below code in your existing work space. try to run below and check.

Load

  NUMBER,

  Num(NUMBER) as NUMBER1,

  NUM(Right(NUMBER, Len(NUMBER)-FindOneOf(NUMBER, '123456789')+1)) as NUMBER2

Inline

[

  NUMBER

  00000978

  00001524

  00001024

  00012356

];




fabioporta
New Contributor

Re: How To Remove Leading Zeros in a Number

Mid(FieldValue, FindOneOf(FieldValue,'123546789'))