Forum Discussion

Mark_Harding's avatar
Mark_Harding
Copper Contributor
Apr 19, 2024

Right function

Hi,

 

Is there a way for the right function to omit zeros from the start of the findings?

My example is: we use the last digits of our item codes to generate a batch number; the format always starts with the letter I and then has 5 numeric following the letter. I only want to capture the numbers greater than zero from the item code!

So if I had our item I01141 it would return 1141, but if I had item I00141 it would return 141 and omit the zeros. Anybody got an idea on how to do this please?

Resources