topic Yet another "For input string" problem -_-' in Talend Studio

Yet another "For input string" problem -_-'

Anonymous — Tue, 31 Jul 2018 16:27:10 GMT

So, I have an .txt file that contains data separated by "|".

I have this file:

And this job:

And this schema:

So, the problem is that I can't get the field "CNPJ" because talend throws this "for input string" error. If I change the schema from "int" to "string" it works. But I want it as integer. So why it isn't working? The first fields are integers too and they are working properly.

What I tried:
- I have searched throws this page and the forum, but didn't find a similar problem.

- I tried to change the type of the file from ".txt" to ".csv".

- I checked the field separator and it is right ("|").

Please help

Re: Yet another "For input string" problem -_-'

TRF — Tue, 31 Jul 2018 16:44:05 GMT

2147483647 is the max value for an interview variable. So the datatype is not compatible with your data.
Try to change the datatype to Long. Max value will be 9223372036854775807L.

Re: Yet another "For input string" problem -_-'

Anonymous — Tue, 31 Jul 2018 17:57:50 GMT

Oh..my...god. I can't believe it was just wrong numeric type choice. Thank you so much!!!