In Toad 9.6.1- 9.7.2.5 when saving the data grid as "Delimited text", the spacing is wrong comparing to Toad 8.6.1.
steps to replicate issue:
1. In the data grid, right click and select "Save As"
2. Choose "Delimited text", clear out the Delimiter character (leave it blank) and hit ok.
Below is a sample of one query and how the result look like when exporting:
select
rpad(sb_rc_mt_subject_id, 4,' '),
rpad(sb_rc_mt_subject_descr, 20,' '),
lpad(active_yn, 2,' ')
from
sb_rc_mt_subject_detail
In Toad 8.6.1
AR Art Y
ES ESOL Y
LS Learning Skills Y
In Toad 9.6.1 -9.7.2.5
AR Art Y
ES ESOL Y
LS Learning Skills Y
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center