Discussion

4
Replies
4310
Views
SumitK98 Member since 2014 7 posts
Mphasis
Posted: 5 years ago
Last activity: 5 years ago
Closed

Remove leading zeros from an integer

Hi,

I have an integer. say an account number which I am getting from DB as 000000000XXXXXXXX. Requirement is to remove all the leading zero's from the value and then display it on the screen. Do we have any function to achieve that?

Note: We cannot use substring function because we are not sure how many leading zero's will be present for that value(means number of zero's are not fixed)

Thanks

Data Integration Java and Activities
Moderation Team has archived post
Share this page LinkedIn