Is there an easy way to remove leading zeros?
Example:
00001234501
I need:
1234501
I can't use Translate because it will catch the zero at the end.
Is there a leading trim function?
Is there an easy way to remove leading zeros?
Example:
00001234501
I need:
1234501
I can't use Translate because it will catch the zero at the end.
Is there a leading trim function?
You can use the number function (Math)
number( '00001234501')