0 - 2 of 2 tags for Bad character in format or data

Hi all,
I have a scenario where i have to CAST most of the columns and create and create a view.
Now the issue i am having is some CASTS fail because of bad format in data. In this case i have to put all failed values as NULL.
becaus of this i am writing a custom code everywhere based on the context.

Hi All,
Not able to figure about the below cause for error. The error is relating to casting. But when i tried cast f12 while inserting the data still i am getting the same error. Please help me to solve this issue.
.logon home/jbhatt,jugal
 .import vartext ',' file=/home/jbhatt/insert.txt
 .quiet on
 .repeat*