|
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 probably one of the most
commonly performed tasks for Database Developers, as it means
taking data which normally appears as vertical text from a row list
and transforming it into a delimited list in 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 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.
|
|
