topic Re: Format BigDecimal, removing decimal Point in Talend Studio

Format BigDecimal, removing decimal Point

Anonymous — Sat, 16 Nov 2024 07:00:42 GMT

Hello friends, a question how to format the numbers according to the following examples:

035190.72

644771.60

285366.60

249985.14

419719.68

03519072

64477160

28536660

24998514

41971968

manodwhb — Wed, 19 Dec 2018 10:59:43 GMT

@guiibarbosaa92,i suggest you to read the column as sting and then use replaceAll function to remove "." and then convert sting to Bigdecimal.

row1.col.removeAll("\\.","")

Anonymous — Wed, 19 Dec 2018 11:03:30 GMT

Hi friend, thanks for you solution.

I got it by using the following solution:

StringHandling.RIGHT("000000000" +mycolumn,9).replace(".", "");

vapukov — Wed, 19 Dec 2018 11:11:09 GMT

-- removed as not proper