TOAD - Search and Replac3

From: E. Bond Francisco <ebondf_at_berkeley.edu>
Date: Mon Sep 20 2004 - 14:29:01 PDT

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/>.
Received on Mon Sep 20 14:32:51 2004

This archive was generated by hypermail 2.1.8 : Mon Sep 20 2004 - 14:33:02 PDT