How to remove CTRL-M (^M) characters from a file in Linux
Removing the ^M character in VIM / VI
:%s/^M//g
Coalesce
When you have an unexpected bad data coalesce it. IF NULL, THEN the alternative in COALESCE
How to remove CTRL-M (^M) characters from a file in Linux
Removing the ^M character in VIM / VI
:%s/^M//g
Coalesce
When you have an unexpected bad data coalesce it. IF NULL, THEN the alternative in COALESCE