copy/paste excel to texteditor -> multi-line text cells gain unwanted double-quotes

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]

I think it does have something to do with the receiving application.

I got the double quotes in NotePad and UltraEdit (another text editor). But I
didn't get them when I pasted into MSWord or WordPad.

And then I could copy from MSWord or Wordpad into NotePad and no double quotes
showed up.

Another option may be to write to a text file directly...

Maybe you could use a macro that writes your data:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

======
Earl's may be sufficient right out of the box. He supports lots of options.

niz wrote:
>
> 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]

--

Dave Peterson