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

[Anonymous]

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

[TRF · Accepted solution]

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.

[Anonymous]

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