SqlDbx Forum

Ike

Guest

Export to Excel, or Copy from DataGrid results in mis-formatted column

Hello - great product! Best of the dozen of free-to-try SQL tools I've tested so far!

When exporting my result set to Excel, or copying the data to the clipboard directly from the resulting data grid, my output gets mis-formatted due to, what I assume to be, formatting characters in my result set.

Is there a way that SQLDBX can export and maintain the columns correctly?

Thanks,
Ike

http://about.me/isaacwyatt

sqldbxhelp

Administrator

Re: Export to Excel, or Copy from DataGrid results in mis-formatted column

Can you please provide examples or screenshots of this issue.

Ike

Guest

Re: Export to Excel, or Copy from DataGrid results in mis-formatted column

Apparently it is the newline/carriage return screwing up the formatting on copy/paste.
I identified the column causing the issue and put in used Oracle's Replace function to remove CHR(10) and replace with a space:
REPLACE(CONTACT.DESCRIPTION,CHR(10),'  ') CONTACT_DESCRIPTION,

Would be nice to -not- to have to do this, but once I figured out the workaround, it is no longer causing trouble.

Thanks!

Ike
http://about.me/isaacwyatt