How to remove decimal points from string field and round off

Highlighted
Six Stars

How to remove decimal points from string field and round off

Hello Folks,

 

I am new to Talend. I need below help.

 

I have input .like this which is String type in .csv file. 

3040000000005.78

 

And I want to convert this to 3040000000006

 

This has removing decimal and round off to nearest integer.

 

Regards,

Deepak

Community Manager

Re: How to remove decimal points from string field and round off

There is a quite a straight forward answer to this using the BigDecimal class. Try this in a tJava component....

 

String stringNum = "3040000000005.78";
BigDecimal bd = new BigDecimal(stringNum);

System.out.println(bd.setScale(0, BigDecimal.ROUND_HALF_UP).toPlainString());

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.