AquaFold
HOME SCREENSHOTS DOWNLOAD DOCUMENTATION SUPPORT LICENSING CONTACT
 

Documentation: Aqua Data Studio 6.5 - New Features     HTML Documentation download, ZIP: ads-docs.zip (Size: 84.7MB) / ads-docs-no-shots.zip (Size: 1.2MB)
  Getting Started
  Installation
  JDBC Drivers
   Oracle 8i
   Oracle 9i
   Oracle 10g
   DB2 7.2
   DB2 8.1
   DB2 9.0
   SQL Server
   Sybase ASE
   Sybase Anywhere
   Sybase IQ
   Informix
   PostgreSQL
   MySQL
  Memory Configuration
  Character sets
  Registering Servers
   MSDE 2000
   SQL Express 2005
   PostgreSQL SSL
  Application
   Browser and Scripting
   Visual Editing
   SQL History and Archive
   Shortcut Toolbar
   Key Mappings
   Key Mapping Assistant
   Custom Keymap Profiles
   Options
   Settings
   New Frame Window
   Details View
   Command Line
  Query Window
   Basics
   Toolbar
   Server Side Comments
   SQL Automation
   Aqua Commands
   Morph to Delimited List
   Results
   Save Results
   Auto-completion
   Popup Menu
   SQL Formatter
   Permissions
   Parameterized
   Pivot Results (Grid and Chart)
   Grid Results (Grid and Chart)
  Editors
   SQL Editor
   Text Editor
   HTML Editor
   XML Editor
   Regular Expressions
  Image Viewer
  Visual Explain Plan
   Basics
   Explain Plan
   Explain Diagram
   Whiteboard
  Procedure/Package Editor
  SQL Debugger
   Sybase Debugger
   Oracle Debugger
  Tools
   Table Data Editor
   Schema Script Generator
   Server Script Generator
   ER Diagram
   Query Builder
   Import Tool
   Export Tool
   Execution Monitor
   Object Search
  Compare Tools
   Schema Compare
   Tab Compare
   Directory Compare
   File Compare
   Copy History Compare
   Results Compare
  Oracle DBA Tools
   Instance Manager
   Storage Manager
   Rollback Manager
   Log Manager
   Security Manager
   Session Manager
   SGA Manager
   Server Statistics
  SQL Server DBA Tools
   Instance Manager
   Storage Manager
   Security Manager
   Session Manager
   SQL Agent Manager
  Sybase DBA Tools
   Instance Manager
   Storage Manager
   Security Manager
   Session Manager
  Source Control
   Subversion
   CVS

Query Window - Morph to Delimited List

A new automate feature has been added under the Automate menu Automate->Morph To Delimited List which allows the user to convert a block of text into a delimited list with the appropriate options.
Query Window - Morph to Delimited List
Simply highlight a block of text in the editor and choose "Morph To Delimited List". The user is then prompted with different options about the source block and the destination block of text, with the result destination overwriting the source block of text. This allows the user to paste text from the Grid Results, Excel or other applications into the editor and then convert them into a comma delimited list or any delimited list which may then be used for completing a query or other documentation.

  • Source
    • Initial Delimiter - Identifies the item delimiter in the original selected block of text so Aqua Data Studio may parse the text.
    • Include line feeds as a delimiter - Identifies whether Aqua Data Studio should recognize a line feed as a delimiter in addition to the initial delimiter.
  • Destination
    • Resulting Delimiter - The delimiter that will be used when generating the resulting block of text.
    • String quoted identifier - The quote identifier for each item in the list if needed.
    • Wrap Line at Column - Determines whether the resulting text should be wrapped and at what column count to wrap.

Morph to Delimited List
Morph to Delimited List
Morph to Delimited list - Separated list
Morph to Delimited list - Separated list
Morph to Delimited list - Separated list Results
Morph to Delimited list - Separated list Results
Home Screenshots Downloads Documentation Support Licensing Contact Copyright© 2001-2007 AquaFold, Inc. All Rights Reserved