Int field conversion Error limit Reached

[Manjari]

Hi All, Requesting your help on resolving field conversion Error limit Reached for int field type

I have a Regex tool with "downloadCount (.*) & viewCount (.*)" where download and viewcount is int64.

I get an error View count not fully converted, I saw posts on string fields and tried something similar to solutions posted but nothing worked.

I still get the error for each row -> "Int field not fully converted error"

In the end I have the error

"View count: Field Conversion Error Limit Reached"

[bbak · Accepted solution]

Maybe try leaving it as the string type it comes in as, use a data cleansing tool on the fields to make sure that there aren't any leading/trailing white space or line breaks, and then use a select tool to change it to int64. 

[Manjari]

Thank you @bbak, this really helped :)

[S_LAM_BHU]

I Have a similar issue where I'm trying to convert text to number with select tool but the number truncates.

Please help what might be the issue