Num format

[#1]

Hi

I have texts with ceros

For example

000031212

00000000000003131

00023232

0000444

I wanna do a 'num' but i wanna ignore the ceros. In this examples i'd like to see

31212

3131

23232

444

I don't know the length of the codes or the ceros

Thank you

Greetings

[sunny_talwar]

May be like this:

Num(Num#(NumberField, '#')) as NumberField

[sunny_talwar · Accepted solution]

Tried it with this as an expression in text box object:

=Num(Num#('000031212', '#'))

and got the following output:

I hope this helps.

Best,

Sunny

[#4]

This worked

Thanks

replace(ltrim(replace(field , '0', ' ')), ' ', 0)

[#5]

that worked too

[sunny_talwar]

I was thinking of using PurgeChar or Replace, but it would replace or purge any 0 from the number also. For example if you have 00000321203 -> output will be 32123 instead of 321203