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());
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.