Purge string

[#1]

Hi,

some of my account numbers comes with seven zeroes in fornt, need to get rid of them, example below:

000000088899

0000000777111

00000003334

000000066666

should be presented as:

88899

777111

3334

66666

what would be the easiest way to remove these zeroes in the script?

[Peter_Cammaert]

=Num(Field, '#0')

[PrashantSangle]

Hi,

use num#(FieldName)

Regards

[#4]

haha, was a bit fast there. Actually it turned all of the "problem accounts" into null.

Any idea why?

Sorry for the hassle.

//O

[qlikmsg4u]

Load Num(value) as Value;

Load * Inline [

value

000000088899

0000000777111

00000003334

000000066666

];

[sunny_talwar]

May be this:

LOAD Num(Num#(Num), '#0') as Num;

[sasiparupudi1]

try num(num#(val)) as value

[#8]

same result im afraid, null values

[qlikmsg4u]

It is working fine for me

Load value,Num(value) as Value1;

Load * Inline [

value

000000088899

0000000777111

00000003334

000000066666

];

[PrashantSangle]

Hi,

Can you post your test app???

Regards