Search the help info for “Find and replace text”.
It shows how to create two macros to wrap text and make it comma separated. Once you create the macros… two clicks and you’re done. Saves a ton of time with
From: Norm [TeamT] [mailto:bounce-NormTeamT@toadworld.com]
Sent: Thursday, November 20, 2014 3:13 PM
Subject: Re: [Toad for Oracle - Discussion Forum] Easy way to include a list without having to put quotes around each item separated by comma?
Easy way to include a list without having to put quotes around each item separated by comma?
Reply by Norm [TeamT]
You can still use your Word macro provided you delve into the settings and turn off so called “smart quotes”.
If I remember, you do it in two places, autocorrect and something while you type.
Then edit the macro to make sure you are using the vanilla single quote and not a smart one.
Norm [ TeamT ]
On 20 November 2014 20:35:25 GMT+00:00, Kennon123 bounce-Kennon123@toadworld.com wrote:
way to include a list without having to put quotes around each item separated by comma?
Thread created by Kennon123
I know it’s not the most tedious task, but when querying with a big list as a filter (the “in” statement), sometimes it’s a pain to use the “find and replace” function for this.
Is there any way to format the query or change some sort of setting where I can just have a long list? In MS Word, I have a macro to do this, but the quote symbol in MS Word is slightly different.
For example, if I want to query all employees in these 20 departments at our company, i would put
To reply, please reply-all to this email.
receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.