Query Window - Morph to Delimited List
Under the Automate menu, Automate > Morph To Delimited List allows the user to convert a block of text into a delimited list with the appropriate options. This is one of the most commonly performed tasks for Database Developers, as it takes data that normally appears as vertical text from a row list and transforms it into a delimited list in a horizontal line of text.
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 originally 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.
Grid Results Paste to Window
Similar, but more powerful, is the right-click context menu within the Grid Results "Paste to Window". By right-clicking on one or more column cells in the Query Grid Results view, you have the option to send the selected cells to the Query Window as Column Select, IN Values, SELECT Rows from Void, SELECT Column Body, INSERT Body, and UPDATE Body. Choosing any of these generates the appropriate DML and includes the highlighted values from the Grid Results.
