Mysterious quote marks appearking in Notepad

[Sirocco]

Has anybody else discovered that when pasting query results in Notepad that
Notepad adds quotation marks around some, but not all, text fields? For
example, Guns "N" Roses becomes "Guns" "N" "Roses" when simply pasted into
Notepad from an Access query. In another case, Notepad added a double
quote mark to the beginning (but not the end) of a text string that didn't
have a quote in the value stored in the database. This is strange and
undesireable, in my opinion. Is there a way to turn this "feature" off, or
is it a bug.

Many thanks in advance.

 

[pietlinden]

Has anybody else discovered that when pasting query results in Notepad that
Notepad adds quotation marks around some, but not all, text fields? For
example, Guns "N" Roses becomes "Guns" "N" "Roses" when simply pasted into
Notepad from an Access query. In another case, Notepad added a double
quote mark to the beginning (but not the end) of a text string that didn't
have a quote in the value stored in the database. This is strange and
undesireable, in my opinion. Is there a way to turn this "feature" off, or
is it a bug.

Many thanks in advance.

Did you try using TransferText?

 

[John Nurick]

Hi Sirocco,

When I try it,
Guns "N" Roses
becomes
"Guns ""N"" Roses"

It's not Notepad that's adding the quote marks, it's Access (they appear
if you paste into another text editor or even paste as plain text into
Word.

As far as I can tell, it happens only to text values that contain one or
more quotation marks. I feel it's inappropriate and don't know a way of
preventing it. You can work round it by exporting the query to a text
file, and setting the "text qualifier" in the text export wizard to
"{none}".

If you can provide a reproducible scenario in which a quotation mark is
added to "the beginning (but not the end) of a text string that didn't
have a quote in the value stored in the database", that's definitely a
bug and I'll make sure it's reported.