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