topic filling number with 0 while exporting using tFileOutputDelimited in Talend Studio

filling number with 0 while exporting using tFileOutputDelimited

stagliaferri1640766615 — Fri, 15 Nov 2024 22:22:34 GMT

Hello Community,

I am creating a very simple job - reading data from database and exporting the result set in csv

using tDBInput to read the data, tFileOutPutDelimited to export the data

in the select statement I am converting an amount as DECIMAL (10,6) so in the result set I have

0.000487
0.144300

etc. etc.

and in the schema I defined it as Double as Type, Decimal as DB type with lenght 10 and precision 6

when I edit the csv output using notepad++ all the zeros as the end of the numbers are gone. so

0.000487 --> in the csv I get
0.000487
0.144300
--> in the csv I get 0.1443

is there a way to have all the 6 decimals even if 0s ?

thanks

sergio

Re: filling number with 0 while exporting using tFileOutputDelimited

Anonymous — Thu, 10 Nov 2022 15:30:53 GMT

I think the easiest way to achieve this is to output the decimals as String to the file (CSV files are essentially file of Strings anyway), then use code like this (maybe in a tMap before the output component) to format the numbers....

String.format("%.6f", row1.doubleColumn)

Re: filling number with 0 while exporting using tFileOutputDelimited

stagliaferri1640766615 — Wed, 16 Nov 2022 08:40:01 GMT

it worked!!! thank you very much!