Double numbers with "." instead of ","

[Anonymous]

Hello, i have a number in string like  "1225,084"

I Replace all "," to "." then converted to double using Double.parseDouble 

Later the number show is a double with "1225,084"

Better way to show "1225.084" or "1225.09"

[Anonymous]

Hi,

    Please refer the below flow where the input data is given as String and the output is in Double.

The tMap function is as shown below

row2.data.replaceAll(",",".") 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hello, in TlogRow all data appears with "."

already but when exported to tfieouput they change to "," I Already did this steps to string to double replacing "," to ".

As u can see this in tLogRow above

And in xls file the number change the formatt

[Anonymous]

I Noticed that exporting to CSV, it appers with "." instead ","

but characters like 1225.085 appears like that in csv "1.225.085"
Because formatted as number but contains only 1225085

There is a way to be show correct like 10.00 ?
Only 2 Decimal Places can be rounded like 10.018 to 10.02

[TRF]

Have a look here for rounding https://www.baeldung.com/java-round-decimal-number

[Anonymous]

After a long test, i noticed that EXCEL was confusing me because it format the numbers, if i open in NOTEPAD they appear correct what i expect

Thanks for all support everybody gave me.

I will no longer use excel to view data HAHAHAHAHHAHA. EXCEL SUCKS