Format BigDecimal, removing decimal Point

[Anonymous]

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

035190.72

644771.60

285366.60

249985.14

419719.68

to

03519072

64477160

28536660

24998514

41971968

[manodwhb]

@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]

Hi friend, thanks for you solution.

I got it by using the following solution:

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

[vapukov]

-- removed as not proper