i have a formula composed of 3 lines in one cell:

=" IF c_MSISDN_NDC" & $E3 & " IS NOT NULL THEN
utl_file.put_line (l_file_handle, '
'||c_pkg||LOWER(l_curr_table)||'(c_new_point +" & $E3 & ", 1,
c_oper_name);');
utl_file.put_line (l_file_handle, '
'||c_pkg||LOWER(l_curr_table)||'(c_new_point +" & $E3 & ", 2,
c_oper_name);');"

this produces a text string, e.g. as below:

" IF c_MSISDN_NDC70 IS NOT NULL THEN
utl_file.put_line (l_file_handle, '
'||c_pkg||LOWER(l_curr_table)||'(c_new_point +70, 1, c_oper_name);');
utl_file.put_line (l_file_handle, '
'||c_pkg||LOWER(l_curr_table)||'(c_new_point +70, 2, c_oper_name);');"

when i try to copy/paste it into a text editor, i get the following:

" IF c_MSISDN_NDC69 IS NOT NULL THEN
utl_file.put_line (l_file_handle, '
'||c_pkg||LOWER(l_curr_table)||'(c_new_point +69, 1, c_oper_name);');
utl_file.put_line (l_file_handle, '
'||c_pkg||LOWER(l_curr_table)||'(c_new_point +69, 2, c_oper_name);');"

as you can see there are unwanted double-quotes at the beginning and
end of the line. this is nothing to do with the texteditor as i get the
double-quotes in notepad also (but there i dont get the linebreaks i
need so i'm using an alternative).

i also tried copy/paste-as-special the results of my formula to another
column, then copy/pasting that new column. same result as above, still
double-quotes. this issue only seems to occur where a cell contains
linebeaks.

any ideas how to not get the double-quotes????

--
[please reply to group]