topic Convert a BigDecimal to Integer - tJavaRow in Talend Studio

Convert a BigDecimal to Integer - tJavaRow

RVeitch_84 — Fri, 15 Nov 2024 22:55:16 GMT

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 — Mon, 16 May 2022 03:27:12 GMT

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