Re: TOAD - Search and Replac3

Bond...

I use Toad quite a bit but do not know that you can do that in the toad SQL
editor.

The way I do what you are attempting is to go into MS Word and use there
search and replace tools which includes special character search and
replace. Then save as a text file and open again with Toad.

You might be able to use Textpad but I am certain Word will do the job.

John

At 02:29 PM 9/20/2004 -0700, you wrote:
>Folks,
>
>In TOAD, in a list of numbers, how would I search for a linefeed and replace
>it with ');(' (not a smilie!)
>
>In other words, I want to format a list of numbers so I can create an insert
>statement out of them:
>
>9999999
>9999998
>
>Becomes:
>
>('9999999');
>('9999998');
>
>
>
>Thanks,
>
>Bond
>-=-=-=-
>E. Bond Francisco
>510-643-5523
>Computer Resource Manager
>CMMS Administrator
>Physical Plant - Campus Services
>UC Berkeley
>
>
>------------------------------------------------------------------------
>The following was automatically added to this message by the list server:
>
>For information about Micronet, including subscribing to
>or unsubscribing from its mailing list and finding out
>about upcoming meetings, please visit the Micronet Web site:
><http://micronet.berkeley.edu/>.

------------------------------------------------------------------------
The following was automatically added to this message by the list server:

For information about Micronet, including subscribing to
or unsubscribing from its mailing list and finding out
about upcoming meetings, please visit the Micronet Web site:
<http://micronet.berkeley.edu/>.
Received on Tue Sep 21 08:35:41 2004