Replace CR in fields with 'nothing'
Posted on 2014-02-14
Hello experts -
question for you:
How I do replace CRLF in UNIX file (AIX OS) with 'nothing'? Example, as file fragment shows in vi:
Desired result will be one line as:
I am looking for the solution like:
sed 's/"CRLF"//g' old_file > new_file, that allows me do bulk replacement of all occurrences of CR-LF in existing 'old_file'. ("CRLF" pattern in sed example is illustration only).
Also, it isn't DOS-to-UNIX conversion. These CRLF got into files that are 'spools' out of Oracle sqlpus when data has CR characters in VARCHAR2(..) columns.