Hpefully some one will have and answer for this.
Excel may add quotation marks automatically upon exporting to a txt file
format.

Has this been addressed in Excel 2007.

Thanks
Steve

Can you explain your problem with this a little more? Or tell us what you
expect to happen and what actually happens?

I haven't investigated the output of .txt type data from Excel, but it is
typical in CSV type files to have quotation marks added to text that contains
the separator character so that the import side of things can tell that a
given separator character is either truly a separator character or is just
another character within a text string.

"Steven" wrote:

Hpefully some one will have and answer for this.
Excel may add quotation marks automatically upon exporting to a txt file
format.

Has this been addressed in Excel 2007.

Thanks
Steve

I have the | "pipe" delimiter set in my pc's global options.
I work up some database info in excel .xls and when one group of products is
done I copy and paste the info into a .txt file.

Keep in mind this happens when ever I use a quote character in any cell.
But in this case I needed to add the alt="" to the below string but after I
save this txt file and open it up in notepad I find quote marks where they
should not be. ie.

"<IMG SRC=%%URLofImages%%/lights_of_america/2413c_thumb.jpg BORDER=0
alt="""""

All I want is what I typed not the extra quote marks.

Steve

"JLatham" wrote:

Can you explain your problem with this a little more? Or tell us what you
expect to happen and what actually happens?

I haven't investigated the output of .txt type data from Excel, but it is
typical in CSV type files to have quotation marks added to text that contains
the separator character so that the import side of things can tell that a
given separator character is either truly a separator character or is just
another character within a text string.

"Steven" wrote:

Hpefully some one will have and answer for this.
Excel may add quotation marks automatically upon exporting to a txt file
format.

Has this been addressed in Excel 2007.

Thanks
Steve

Steven,
Let me play around with this for a bit. I see what you're talking about:
Alt="" being turned into Alt="""". That's something I'd expect to see in a
..CSV type file where the double-quote character is used as the text delimiter
and also happens to appear within a string that contains them.

One more question: in your first post you said you were exporting the data
to a file from Excel, in this last one you mention copy and paste. Which
method are you using?

"Steven" wrote:

I have the | "pipe" delimiter set in my pc's global options.
I work up some database info in excel .xls and when one group of products is
done I copy and paste the info into a .txt file.

Keep in mind this happens when ever I use a quote character in any cell.
But in this case I needed to add the alt="" to the below string but after I
save this txt file and open it up in notepad I find quote marks where they
should not be. ie.

"<IMG SRC=%%URLofImages%%/lights_of_america/2413c_thumb.jpg BORDER=0
alt="""""

All I want is what I typed not the extra quote marks.

Steve

"JLatham" wrote:

Can you explain your problem with this a little more? Or tell us what you
expect to happen and what actually happens?

I haven't investigated the output of .txt type data from Excel, but it is
typical in CSV type files to have quotation marks added to text that contains
the separator character so that the import side of things can tell that a
given separator character is either truly a separator character or is just
another character within a text string.

"Steven" wrote:

Hpefully some one will have and answer for this.
Excel may add quotation marks automatically upon exporting to a txt file
format.

Has this been addressed in Excel 2007.

Thanks
Steve

It's copy and paste from xls to a txt file. It's not just the alt= it's also
the " at the beginning and end of the image url too.

Thnaks Steve

"JLatham" wrote:

Steven,
Let me play around with this for a bit. I see what you're talking about:
Alt="" being turned into Alt="""". That's something I'd expect to see in a
.CSV type file where the double-quote character is used as the text delimiter
and also happens to appear within a string that contains them.

One more question: in your first post you said you were exporting the data
to a file from Excel, in this last one you mention copy and paste. Which
method are you using?

"Steven" wrote:

I have the | "pipe" delimiter set in my pc's global options.
I work up some database info in excel .xls and when one group of products is
done I copy and paste the info into a .txt file.

Keep in mind this happens when ever I use a quote character in any cell.
But in this case I needed to add the alt="" to the below string but after I
save this txt file and open it up in notepad I find quote marks where they
should not be. ie.

"<IMG SRC=%%URLofImages%%/lights_of_america/2413c_thumb.jpg BORDER=0
alt="""""

All I want is what I typed not the extra quote marks.

Steve

"JLatham" wrote:

Can you explain your problem with this a little more? Or tell us what you
expect to happen and what actually happens?

I haven't investigated the output of .txt type data from Excel, but it is
typical in CSV type files to have quotation marks added to text that contains
the separator character so that the import side of things can tell that a
given separator character is either truly a separator character or is just
another character within a text string.

"Steven" wrote:

Hpefully some one will have and answer for this.
Excel may add quotation marks automatically upon exporting to a txt file
format.

Has this been addressed in Excel 2007.

Thanks
Steve

Thanks for that - and for the info about the " at beginning and end of
phrase. I meant to ask about those but didn't. Be back shortly <g.

"Steven" wrote:

It's copy and paste from xls to a txt file. It's not just the alt= it's also
the " at the beginning and end of the image url too.

Thnaks Steve

"JLatham" wrote:

Steven,
Let me play around with this for a bit. I see what you're talking about:
Alt="" being turned into Alt="""". That's something I'd expect to see in a
.CSV type file where the double-quote character is used as the text delimiter
and also happens to appear within a string that contains them.

One more question: in your first post you said you were exporting the data
to a file from Excel, in this last one you mention copy and paste. Which
method are you using?

"Steven" wrote:

I have the | "pipe" delimiter set in my pc's global options.
I work up some database info in excel .xls and when one group of products is
done I copy and paste the info into a .txt file.

Keep in mind this happens when ever I use a quote character in any cell.
But in this case I needed to add the alt="" to the below string but after I
save this txt file and open it up in notepad I find quote marks where they
should not be. ie.

"<IMG SRC=%%URLofImages%%/lights_of_america/2413c_thumb.jpg BORDER=0
alt="""""

All I want is what I typed not the extra quote marks.

Steve

"JLatham" wrote:

Can you explain your problem with this a little more? Or tell us what you
expect to happen and what actually happens?

I haven't investigated the output of .txt type data from Excel, but it is
typical in CSV type files to have quotation marks added to text that contains
the separator character so that the import side of things can tell that a
given separator character is either truly a separator character or is just
another character within a text string.

"Steven" wrote:

Hpefully some one will have and answer for this.
Excel may add quotation marks automatically upon exporting to a txt file
format.

Has this been addressed in Excel 2007.

Thanks
Steve

Steven,
I've tried this in both Excel 2007 and Excel 2003 (both systems with Windows
XP Pro as the operating system).

I cannot duplicate your problem with either version of Excel if I simply
select the cell(s) and do an [Ctrl]+[C] to copy it to the clipboard and then
use [Ctrl]+[V] to paste it into Notepad to be saved as a text file.

But I can duplicate it in both versions if I use File | Save As and then
choose the .txt file option in the Save As Type list.

So I guess the answer to your original, basic question is that the behavior
has not changed from 2003 to 2007.


"Steven" wrote:

It's copy and paste from xls to a txt file. It's not just the alt= it's also
the " at the beginning and end of the image url too.

Thnaks Steve

"JLatham" wrote:

Steven,
Let me play around with this for a bit. I see what you're talking about:
Alt="" being turned into Alt="""". That's something I'd expect to see in a
.CSV type file where the double-quote character is used as the text delimiter
and also happens to appear within a string that contains them.

One more question: in your first post you said you were exporting the data
to a file from Excel, in this last one you mention copy and paste. Which
method are you using?

"Steven" wrote:

I have the | "pipe" delimiter set in my pc's global options.
I work up some database info in excel .xls and when one group of products is
done I copy and paste the info into a .txt file.

Keep in mind this happens when ever I use a quote character in any cell.
But in this case I needed to add the alt="" to the below string but after I
save this txt file and open it up in notepad I find quote marks where they
should not be. ie.

"<IMG SRC=%%URLofImages%%/lights_of_america/2413c_thumb.jpg BORDER=0
alt="""""

All I want is what I typed not the extra quote marks.

Steve

"JLatham" wrote:

Can you explain your problem with this a little more? Or tell us what you
expect to happen and what actually happens?

I haven't investigated the output of .txt type data from Excel, but it is
typical in CSV type files to have quotation marks added to text that contains
the separator character so that the import side of things can tell that a
given separator character is either truly a separator character or is just
another character within a text string.

"Steven" wrote:

Hpefully some one will have and answer for this.
Excel may add quotation marks automatically upon exporting to a txt file
format.

Has this been addressed in Excel 2007.

Thanks
Steve