Remove Preceding 0 from script level

[arvind_patil]

Hi Experts,

I have one GL FIeld in that  values are like below

0011101033

08546880

000111222333

Required Output

11101033

8546880

111222333

Note : I have checked with  Num and Num # Function .

Thanks,

Arvind Patil

[micheledenardi · Accepted solution]

Replace(LTrim(Replace(YourField, '0', ' ')), ' ', '0')  as [YourFieldWithoutLeadingZeros]

[Chanty4u]

its working for me

load * ,num(aaa) as new;

load  * Inline

[

aaa

0011101033

08546880

000111222333

];

[Chanty4u]

[Chanty4u]

or try this

LOAD *, Number8digit+0 As Number;

LOAD * Inline [

Number8digit

00000978

00001524

00001024

00012356

];

[Chanty4u]

this also you can try

Load

  NUMBER,

  Num(NUMBER) as NUMBER1,

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

Inline

[

  NUMBER

  00000978

  00001524

  00001024

  00012356

];

[arvind_patil]

No its not  working for me.

Thanks,

Arvind Patil

[PrashantSangle]

can you share sample file or screen shot of what are you trying???

Regards,

Prashant

[arvind_patil]

Hi Michele,

Thanks for prompt reply it works for me .

But  I am very enthusiastic to understand why num and num # not worked.

Thanks,

Arvind Patil

[arvind_patil]

HI Chanty,

I tried your answers but it wont work for me.

Thanks,

Arvind Patil