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());
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Move from On-Premises to the Cloud by following the advice of experts
Learn about modern data engineering in the Cloud
Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries