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.
Bookmarks