S
Steve Basile
I'm having a hard time getting Excel to save field delimiter quote marks.
The commas are there but no quote marks.
Help!
Steve B
The commas are there but no quote marks.
Help!
Steve B
L
little_creature
Hello,
I find this on the topics:
http://groups.google.com/groups?q=35f94c3898d2d1c1
Seems the only workaround is to use Macro. I have found this:
http://support.microsoft.com/kb/291296
On third attempt I have managed it to work. (needs to select the area with
data first
as mentioned)
Hope this will help.
I find this on the topics:
http://groups.google.com/groups?q=35f94c3898d2d1c1
Seems the only workaround is to use Macro. I have found this:
http://support.microsoft.com/kb/291296
On third attempt I have managed it to work. (needs to select the area with
data first
as mentioned)Hope this will help.
S
Steve Basile
The macro at the link you posted did the trick.
Thank you!
Steve
little_creature wrote on 12/13/06 11:52 AM:
Thank you!
Steve
little_creature wrote on 12/13/06 11:52 AM:
C
CyberTaz
Hi Steve -
Perhaps in this case the receiving app requires the quotes, but that is
somewhat arcane. CSV typically doesn't enclose text strings in quotes unless
the field (cell) content includes a comma. Especially if the file is going
to a text-based app, it's actually better that the quotes not be there - the
user at the other end just has to edit them out.
The quotation marks (which were previously the norm in comma delimited text
files) are appropriately referred to as Text Qualifiers, not Field
Delimiters. The comma is the delimiter which separates the content of one
field from the next in a record. Quotes were previously used to denote text
content as opposed to values so the receiving app could tell the difference
between the two types of data. Modern software is much "smarter" than the
old stuff, so the quotes are no longer necessary. That's the format CSV was
designed to support, superceding the older Comma Delimited Text File format.
CSV output from PC XL(2003) works the same way.
Regards |:>)
Bob Jones
[MVP] Office:Mac
Perhaps in this case the receiving app requires the quotes, but that is
somewhat arcane. CSV typically doesn't enclose text strings in quotes unless
the field (cell) content includes a comma. Especially if the file is going
to a text-based app, it's actually better that the quotes not be there - the
user at the other end just has to edit them out.
The quotation marks (which were previously the norm in comma delimited text
files) are appropriately referred to as Text Qualifiers, not Field
Delimiters. The comma is the delimiter which separates the content of one
field from the next in a record. Quotes were previously used to denote text
content as opposed to values so the receiving app could tell the difference
between the two types of data. Modern software is much "smarter" than the
old stuff, so the quotes are no longer necessary. That's the format CSV was
designed to support, superceding the older Comma Delimited Text File format.
CSV output from PC XL(2003) works the same way.
Regards |:>)
Bob Jones
[MVP] Office:Mac