SqlDbx
You are not logged in.
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
Can you please provide examples or screenshots of this issue.
Offline
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!