ORA-01722 – Invalid number with SQL*Loader in unix

When tring to load data using SQL*Loader Invalid number error popped up.

The last column in the staging table was a number. Having tried trim and nullable etc. I found that the data file has got funny chars. The data file was copied from windows.

Solution:
dos2unix filename.dat