ou can remove the ^M by doing the following:
Bring the datafile into the Unix editor vi. In command mode you would type in:
:1,$s/^V^M//
Make sure you are entering ‘control V’ and ‘control M’. The ‘control V’ says
to accept the next character exactly as I type it. Adding the two slashes at
the end of the command says to subsitute the ^M with null.