Discussion

4
Replies
5553
Views
 Sumit Kalra (SumitK98)
Mphasis

Mphasis
IN
SumitK98 Member since 2014 7 posts
Mphasis
Posted: July 15, 2015
Last activity: August 30, 2015
Posted: 15 Jul 2015 7:06 EDT
Last activity: 30 Aug 2015 13:41 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.
Posted: 6 years ago
Posted: 15 Jul 2015 15:45 EDT
Saurabh Arora (SA_Arora)
Cognizant Technology Solutions
Technology Architect
Cognizant Technology Solutions
US

Try using the function - "@toInt". this converts a string to integer. The leading zeros should be truncated automatically.
Posted: 6 years ago
Posted: 16 Jul 2015 3:13 EDT
Sumit Kalra (SumitK98)
Mphasis

Mphasis
IN

Thanks SA. But, the account number that I have is a large number and it always falls out of range of integer.