remove 0

[#1]

Hi,

I have data like following.

How can i remove all the 0 before the real digits?

Thanks.

000000001234

000000334456

000000043467

[sivarajs]

use floor(fieldname) or num(fieldname)

[#3]

Hi,

you can also try

purgechar(000000001234,'0')

[sivarajs]

@keeruthi   Purgechar is not a good idea because

000001234-->1234

0000012034-->1234

You'll get wrong value

[#5]

@Siva,

   tht's wht he wants right??

"How can i remove all the 0 before the real digits?" --to remove zero's before the digits..,

i understood the problem in that way  🙂

[#6]

Hi All,

Good ideas ! n

Non works though.

Any other ways?

[CELAMBARASAN]

Try with Num(FieldName)

[#8]

This is strange...

i created a test qvw, with some inline data, n i type in the data pattern.

then i apply num(), it works !

BUT, when i extract the code form SAP. and i do num(). it doesn't.

nor... floor(num()) or purgechar(num()) or num(num())

anymore advises?

[matt_crowther · Accepted solution]

Nick,

num() seems to work with me - not against SAP data though.

As a 'ye haw!!' cowboy workaround I'd try something like the following in the load script to chop the field down to size:

right(Number,len(Number)-(FindOneOf(Number,'123456789'))+1)

Hope that helps,

Matt

@QlikviewBI

[CELAMBARASAN]

May be SAP adds some char to the string data

Try this

Num(KeepChar(FieldName,'0123456789'))

Hope it may solves the problem

Celambarasan