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