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?