Trim zeros

[nareshthavidishetty]

Hi,

I have a field and it has data like 002,003,096,099..

Here i need to remove only zeros.

The final required output would be 2,3,96,99

Field : Location

Thanks..

[m_woolf]

see the replace() string function in Help

[albertovarela]

Try replace(ltrim(replace(YourField,'0',' ')),' ','0')

[Anonymous]

You could try this if you field has numbers and letters:

if(isnum(YourField),num(YourField),YourField)

If you're certain the data will always be numeric than you would just need num(YourField)

[cmsjamesgreen]

Try a combination of Mid() and FindOneOf()

=Mid(Location, FindOneOf(Location, '123456789'))

[Peter_Cammaert]

Or if you cannot rely on the default masks, you can also use an explicit format that does away with the leading zeroes:

=num(Field, '#0')

[jonas_rezende]

Hi, nareshthavidishetty nareshthavidishetty.

Try simply num(Field).

I hope this helps.

[MarcoWedel]

or maybe

Location*1

hope this helps

regards

Marco

[Anil_Babu_Samineni]

What is the output you want to see for below Input

Load * Inline [

Location

001

002

300

400

030

099

330

];

Expected output please?

[sdmech81]

Hi,

May be try =num(yourfiled)

if doesn't work then plss use like

=Right(yourfield,1)

Sachin