M
Martha
I want to Find and Replace a sequence of text
characters, "||", with Alt-Enter (carriage return). The
Find/Replace does not allow me to enter Alt-Enter or Char
(10) or 0x0A as the replacement characters.
The reason I am stuck doing this is because I am pulling
data, via a SELECT/REPLACE statement from an Oracle
database that contains multi-line text (Chr(10)). No
matter what I try in SQLPLUS, it corrupts other fields
unless I replace it with a regular Ascii character
sequence such as "||". I have tried double quoting and
other format tricks, but nothing allows me to build the
csv file properly to Excel can load it, if it contains the
Alt-Enter characters. Therefore, I finally converted it
to ascii characters and want to manually convert it back
after I open up my Excel file by using Search/Replace.
characters, "||", with Alt-Enter (carriage return). The
Find/Replace does not allow me to enter Alt-Enter or Char
(10) or 0x0A as the replacement characters.
The reason I am stuck doing this is because I am pulling
data, via a SELECT/REPLACE statement from an Oracle
database that contains multi-line text (Chr(10)). No
matter what I try in SQLPLUS, it corrupts other fields
unless I replace it with a regular Ascii character
sequence such as "||". I have tried double quoting and
other format tricks, but nothing allows me to build the
csv file properly to Excel can load it, if it contains the
Alt-Enter characters. Therefore, I finally converted it
to ascii characters and want to manually convert it back
after I open up my Excel file by using Search/Replace.