Return
-
Title
Request option to trim trailing spaces when exporting CHAR data to Excel -
Description
When exporting data to Excel which has CHAR columns, the cells in the Excel worksheet are padded with trailing spaces (since CHAR is a fixed length field). Request export option to trim trailing spaces for CHAR columns.
-
Resolution
WORKAROUND:
Add RTRIM() function to original query
STATUS:
Enhancement request ST60835 has been submitted to Development for consideration in a future release of Toad for Data Analysts -
Defect ID
ST60835