I am new to Talend. I need below help.
I have input .like this which is String type in .csv file.
And I want to convert this to 3040000000006
This has removing decimal and round off to nearest integer.
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());
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.