concat strings

melanie_pfefer · #1 (**permalink**) 12-04-2007

Hello,

I have a list of tablespaces in oracle and I want to concatenate 'drop tablespace' on the left of each line and 'INCLUDING CONTENTS AND DATAFILES' on the right of each line.

Any idea how to do that?

many thanks.

PS: I tried to use excel and copy/paste it to vi. But I noticed many \240 between strings

vino · #2 (**permalink**) 12-04-2007

If you have it in MS-Excel, save it as a .txt file.

On the .txt file do this

Code:

sed -e "s/.*/drop tablespace & INCLUDING CONTENTS AND DATAFILES/g" file.txt

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
simple question on string concat	the_learner	High Level Programming	2	08-23-2007 11:09 PM
concat fields	markjason	Shell Programming and Scripting	10	10-23-2006 02:38 PM
concat string	mpang_	Shell Programming and Scripting	1	07-25-2006 06:03 AM
Concat	dhananjaysk	Shell Programming and Scripting	1	03-20-2006 07:42 AM
Concat date	drukkie	UNIX for Dummies Questions & Answers	2	05-30-2002 07:36 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by