topic Re: Exception in component tFileInputDelimited_1 NumberFormatException For input String in Data Quality

Exception in component tFileInputDelimited_1 NumberFormatException For input String

yassine3 — Fri, 04 May 2018 16:36:15 GMT

Hi,

I am facing "NumberFormatException" Error. Please tell me how to solve this issue?

Exception in component tFileInputDelimited_1

Java.lang.NumberFormatException: for input string: "-25416.45"

at java.lang.NumberFormatException.forInput(Unkown Source)

at java.lang.Integer.parsInt(Unkown Source)

at routine.system.ParserUtils.parseTo_Int(ParserUtils.java:105)

at routine.system.ParserUtils.parseTo_Integer(ParserUtils.java:112)

Type of column is Double 22,9

Please Help me

vboppudi — Fri, 04 May 2018 17:35:11 GMT

Hi,

Are you trying to convert input string to double?

Please provide more details of your job.

Regards,

Anonymous — Mon, 07 May 2018 07:08:08 GMT

Hello,

Screenshots of your job setting will be preferred.

Best regards

Sabrina

yassine3 — Mon, 07 May 2018 08:43:28 GMT

Hello,

Below the screenshot

Thank you for your help

yassine3 — Mon, 07 May 2018 08:45:08 GMT

Hi Veeranjaneyulu

I m trying to add column double to an mssqlOutput double too.