I have a field with the following values
The field is in number format.
The length of the field is constant and it is 8.
I would like to remove the leading zeros and would like to have the values as follows:
Kindly help me to get the above output.
Thanks in Advance!!
you can perform below code in your existing work space. try to run below and check.
Num(NUMBER) as NUMBER1,
NUM(Right(NUMBER, Len(NUMBER)-FindOneOf(NUMBER, '123456789')+1)) as NUMBER2