topic Re: Convert String to Int in Talend Studio

Convert String to Int

thomas_2583 — Fri, 15 Nov 2024 22:48:25 GMT

Hi,

I am trying to convert my String value to an Integer, but not having any luck. The field either has a number, or a NULL.

I have tried the following within TMap, but this doesn't work

Integer.parseInt(row1.comp_number)

Any idea how to pass this through, please?

InfoCraft — Mon, 20 Jun 2022 14:49:48 GMT

Hi @Steven Littlewood ,

try this using tMap or tJavaRow...

row1.comp_number!=null && !row1.comp_number.trim().equals("")? Integer.valueOf(row1.comp_number):null

++++gift

Select as Best if its OK

Kind regards,

😷19.

thomas_2583 — Mon, 20 Jun 2022 19:16:05 GMT

Thank you so much for your help, that has worked for me. Thank you also for the hint sheet, I am sure this will come in very useful!