Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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.

9 Replies
Highlighted

Hi

Try like this

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

or

Num(FieldName)

Highlighted
Specialist III
Specialist III

Use the script below

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

Capture.PNG.png

Highlighted
MVP
MVP

Load

  NUMBER,

  Num(NUMBER) as NUMBER1,

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

Inline

[

  NUMBER

  00000978

  00001524

  00001024

  00012356

];

Highlighted

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

Highlighted

Num(YourField)


should be the easiest way.

Highlighted
Not applicable

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

];




Highlighted
Contributor
Contributor

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

Highlighted
Contributor III
Contributor III

this worked for me:

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

 

 

Highlighted
Creator
Creator

this one worked perfectly