On 5/2/02 7:18 AM, "Jim Colgate" <[EMAIL PROTECTED]> wrote:

> I�m still curious as to why the first recipient display name did not have
> the leading quote or quotes and only had trailing quotes when there were two
> of them. Some intelligence must be stripping them, but only for the first
> entry in the recipList.

Excel, and some other MS apps on Windows, have a rather clever system for
understanding special characters such as carriage returns, tab characters,
commas, and other marks which may be used as delimiters. If they are meant
to be used literally, not as delimiters, they are placed between quotes in
the text file. Excel then does not transcribe the outer quotes themselves,
but looks for the closing quotes. _This_ may be why the < >  characters are
not messing up your import - if the very first character in your text file
is a double-quote, the < > signs may be imported literally instead of as
some sort of special signifier. With this  quoting method, real literal
quotes have to be doubled up "", at least in  Windows.  If you try to Save
As... tab-delimited text _from_ an Excel Worksheet, you'll find dozens and
dozens of extra quotes, surrounding any field (exported cell) which contains
punctuation, which can be a big nuisance.

-- 
Paul Berkowitz


--
To unsubscribe:                     <mailto:[EMAIL PROTECTED]>
archives:       <http://www.mail-archive.com/entourage-talk%40lists.letterrip.com/>
old-archive:       <http://www.mail-archive.com/entourage-talk%40lists.boingo.com/>

Reply via email to