Multiple 0s redact

[SP3000]

Hi,

I need to redact the multiple 0s in front of numbers in like mentioned in the below table, can someone please help with the best way to do it? 

No	Desired no
0000012345	12345
0000123	123
000000123456789	123456789
001234567	1234567

[Luke_C · Accepted solution]

Hi @SP3000 

You can use the TrimLeft() Function:

trimleft([No],'0')

[SP3000]

Wow, just like that ..thank you so much @Luke !! 

[MarqueeCrew]

@SP3000 ,

I completely agree with @Luke_C  on the trimleft() function.  If you want a "NUMBER" you can also convert ToNumber() the entry and that will remove all of the multiple zeros naturally.

Cheers,

Mark