Convert a BigDecimal to Integer - tJavaRow

[RVeitch_84]

I need to convert a BigDec to Int:

Here is a sample of my source data as a BigDec via a tFileInputExcel

153227.49

and I would like to convert it into an INT using tJavaRow to show the following result

15322749

Let me know if you have any questions and thanks for any help.

~Bob

[Anonymous]

Hi

Just remove the period from the source data? If so, try this expression to convert BigDecimal to integer type.

output_row.c1 = Integer.parseInt((input_row.c1.toString()).replaceAll("\\.",""));

Regards

Shong