Convert String to Int

[thomas_2583]

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 · Accepted solution]

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]

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!