Remove leading zeros from an integer | Collaboration Center

Discussion

4

Replies

4888

Views

Member since 2014

Mphasis

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

Cognizant Technology Solutions

replied to SumitK98

Try using the function - "@toInt". this converts a string to integer. The leading zeros should be truncated automatically.

Mphasis

replied to SumitK98

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

Virtusa Corp.

replied to SumitK98

You can use @toDecimal function which truncates the leading zeros

BendeRaghunatha

Incessant Technologies

replied to SumitK98

You can use @toDecimal function which truncates the leading zeros

Contact a Moderator