Guy, need a little help

I will be converting data from Informix to another database but ran into a problem with character fields

some of the data in char fields contain special characters that look like \^M
in vi so obviously the line gets split and can not be loaded into anywhere.
Taking the characters in vi is easy but still get stuck with the line breaks

Probably need to do it via SQL in the table

Has anybody run into this problem? Any suggestions on how to fix the data?

Any help greatly appreciated