Remove Leading ZEROS

[Former Member]

HI all

Please suggest me how to remove the leading zeros using standard functions available in Graphical Mapping

Regards

Bhasker

[Former Member · Accepted solution]

No standard function available for this. Search in SDN. Simple UDFs will do the trick and the code has already been posted in SDN several times.

[Shabarish_Nair · Accepted solution]

>

> No standard function available for this. Search in SDN. Simple UDFs will do the trick and the code has already been posted in SDN several times.

formatnum should do the trick

[Former Member · Accepted solution]

>>formatnum should do the trick

Yes and no. Yes, if the input is always numeric and no if the input can be alpha numeric

[Shabarish_Nair · Accepted solution]

agreed on the alphanumeric part

[Former Member · Accepted solution]

Hi all,

Thank u one and all for your responses

Regards

Bhasker

[Former Member]

Hi Bhaskar,

Check my reply in this thread:

Regards,

---Satish

[Shabarish_Nair]

use the formatnum function for this

[Shabarish_Nair]

additional info:

in the formatnum function provide the property of the number format to #0