Hello friends, a question how to format the numbers according to the following examples:
@guiibarbosaa92,i suggest you to read the column as sting and then use replaceAll function to remove "." and then convert sting to Bigdecimal.
Hi friend, thanks for you solution.
I got it by using the following solution:
StringHandling.RIGHT("000000000" +mycolumn,9).replace(".", "");
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Accelerate your data lake projects with an agile approach