Bug #9044 Clipboard format for copy rows operations
Submitted: 8 Mar 2005 9:24 Modified: 25 May 2012 10:00
Reporter: Emanuele Dolis Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Query Browser Severity:S4 (Feature request)
Version:1.1.5 OS:Windows (Windows XP SP2)
Assigned to: CPU Architecture:Any

[8 Mar 2005 9:24] Emanuele Dolis
Description:
Well,
I don't know if this is by design, but just in case...

In order to make quck analyses of data retrieved in MySQL QB, I often copy row sets in order to paste it in MS Excel.
unfortunately, the format of data copied into the clipboard isn't compatible with Excel, resulting in comma-separated delimited text, which is not arranged in separated columns 
This compels to export to a xls workbook, open it, copying and pasting, closing the workbook, delete it.... 

How to repeat:
a) create a query which outputs two columns of strings
b) select rows and use 'Copy Row values'
c) past e into Excel
d) the expected result is tho columns of cells filled with individual field values

column A           column B
|0216           | prese/cons.suppl.seconda cint. |
|0217           |prese/cons.suppl.da km.26 a 50 |
|0218           |prese/cons.suppl.da km 51 a 75 |
the result is instead something like
column A                                                          column B
'0216', 'prese/cons.suppl.seconda cint.'       |                            |
'0217', 'prese/cons.suppl.da km.26 a 50'      |                            |
'0218', 'prese/cons.suppl.da km 51 a 75'      |                            |
[8 Mar 2005 17:28] Aleksey Kishkin
Hi!
Actually it's a feature request rather than bug. Could you please change 'severity' of this bug report to 'feature request' and status to 'Open' again.
[8 Mar 2005 19:22] Emanuele Dolis
Changed Severity
[8 Apr 2005 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[25 May 2008 21:17] Brendan B
A related problem comes when exporting text fields that contain apostrophes.  Since Query Browser uses the apostrophe as a text delimiter, it will output field values like 'don't' or 'I'll'.  This obviously causes problems when trying to import the data elsewhere, since the delimiter is indistinguishable from the apostrophe that is part of the cell contents.

Ideally, there'd be an option in Query Browser to set the field and text delimiter characters.  Is there any hope of this?
[25 May 2012 10:00] Valeriy Kravchuk
Not supported since December 18, 2009. See http://www.mysql.com/support/eol-notice.html