topic [resolved] CONVERT STRING TO INTEGER in Talend Studio

[resolved] CONVERT STRING TO INTEGER

Anonymous — Mon, 15 Feb 2016 15:17:04 GMT

Hello All,
I want to convert my input column (String type) to Integer in my tMap
In my input i have these values for exemple
"0.23"
"2.45"
"9.57"
So i test these both function: Integer.parseInt() or Integer.valueOf().
But it does not. I also change all dot to comma in input like that:
"0,23"
"2,45"
"9,57"
But nothing
Thanks for help,

Re: [resolved] CONVERT STRING TO INTEGER

Anonymous — Mon, 15 Feb 2016 16:15:25 GMT

You probably need to get rid of the quotes first.

Re: [resolved] CONVERT STRING TO INTEGER

Anonymous — Mon, 15 Feb 2016 16:28:08 GMT

Hi janhess2,
I am not sure because i make test with a small job but it does not work.
See the screenshot of job please

And down the config of tFixeFlowInput component

Thanks for help,

Re: [resolved] CONVERT STRING TO INTEGER

Anonymous — Tue, 16 Feb 2016 02:16:33 GMT

Hi IDEMBELE,
What error does the console state when running your small test job?
Also, the Integer data type cannot hold decimal values, only the whole numbers. I think that is whats causing the error. You have to either:

change input values to whole numbers; or
change Integer data type to float or some other similar data type that handles decimals

Re: [resolved] CONVERT STRING TO INTEGER

Anonymous — Mon, 09 May 2016 13:34:56 GMT

Thanks junmilsso