Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Automation Export. The output results trims spaces causing the fields to shift. Using regular Export (non Automation), the issue does not happen. (4302001)
Automation Export. The output results trims spaces causing the fields to shift. Using regular Export (non Automation), the issue does not happen.
Description
Open a SQL query file in Editor | run it | right-click the data results | Export Wizard | choose ‘Delimited Text’ | column delimiter is Pipe | save output as text file | open the text file | the spaces in the data looks good and as intended.
Now if the same steps above is done via Automation (open Automation | Export Wizard | load the same SQL query file and choose the same settings as above) | save the Automation | then Run the Automation | open the generated output text file. The spacing in the data is now ‘removed’ or ‘trimmed’ causing the fields to shift. It is trimming the interior spaces causing the fields to shift.
Resolution
WORKAROUND:
None.
STATUS:
The issue has been resolved in Toad Data Point 4.0.1. Please download the new release here.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Recommended Content
Product(s):
Toad Data Point
Topic(s):
Troubleshooting
Article History:
Created on: 9/8/2016 Last Update on: 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
Search All Articles
IE 8, 9, & 10 No longer supported
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.
