concat strings

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting concat strings
# 1  
Old 12-04-2007
concat strings


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
# 2  
Old 12-04-2007
If you have it in MS-Excel, save it as a .txt file.

On the .txt file do this

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

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Concat name

Hi, I need help to combine the first 7 character of firstname if it is longer than 7and combine with the first character of lastname. ex: username lastname => usernaml user lastname => userl Thanks in advance. (10 Replies)
Discussion started by: xitrum
10 Replies

2. Shell Programming and Scripting

Concat strings without spaces...

Hello, I have a very travial question....when i run the below can i change my script that will give me an output pf "this is log_vp1" ....i dont want any spaces between log_vp and 1 or any other character...i know i can set a variable for 1(lets say num is the var) and then do... (2 Replies)
Discussion started by: crazy_max
2 Replies

3. Shell Programming and Scripting

How to concat columns?

Hello All, I have a file with following data. 1365787116 3.0 contracts/Procs_Val_Req_forContrct_Amnd_BPEL 1348791394 2.0 contracts/Procs_Val_toTerm_Ret_Contrct_BPEL 1348791394 2.0 contracts/Qualfy_BP_forNew_Ret_Contrct_BPEL 1348791394 2.0 ... (8 Replies)
Discussion started by: Vikram_Tanwar12
8 Replies

4. Shell Programming and Scripting

Concat required

Hi Folks The below is code is giving me value 30. cal | sed '/^$/d' | tail -1 | awk '{printf $NF-1}' Actually the text is like below. echo "you should reply on 30-Jan-2013 evening EST. Here how should i con-cat above logic in that text? (1 Reply)
Discussion started by: coolboy98699
1 Replies

5. Shell Programming and Scripting


Hi All, My Input file contains: Input.txt Name|Marks ABC|10 GHI|10 JKL|20 MNO|20 PQR|30 Output.txt MARKS|NAME 10|ABC,GHI 20|JKL,MNO 30|PQR Thanks in advance (4 Replies)
Discussion started by: kmsekhar
4 Replies

6. Shell Programming and Scripting

concat 3 files

Hello Unix gurus, how to concat 3 files content side by side . i have 3 files more report1.txt select *from tab1 A JOIN tab1 B ON more report2.txt A.PK1=B.PK1 where more report3.txt A.AAA <> B.AAA or A.BBB <> B.BBB or A.CCC<> B.CCCC or .. .. .. A.ZZZ <> B.ZZZ; if i concatinate... (3 Replies)
Discussion started by: kanakaraju
3 Replies

7. Solaris

Concat strings in Sun Solaris

Hi I am using solaris 10 #!/bin/ksh today=`date` GrepDate=`echo $today | awk '{print $1,$2,$3}'` echo $GrepDate output is "Mon Mar 8" But i need to get output like "Mon Mar 8"(two spaces b/w Mar & 8) Please help Regards Arun (6 Replies)
Discussion started by: annyarun
6 Replies

8. Shell Programming and Scripting

concat fields

hi I have a file, I need to concatenate depening on the no of columns i need to concatenate. for example i need to concatenate field1,filed34,field2( no of columns is not always 3, it can be any number of fields) concat.ksh field1 field34 field2 how to achieve this, is there any argv ,argc... (10 Replies)
Discussion started by: markjason
10 Replies

9. Shell Programming and Scripting

concat string

hey, I want to concat whole bunch of strings together but somehow they don't turn out the way I want them to a="HELLO " b="WORLD " c=$a$b I was expecting c to be "HELLO WORLD " but it... (1 Reply)
Discussion started by: mpang_
1 Replies

10. Shell Programming and Scripting


HI all, How to concat two strings in Shell scrpits suppose x=a y=b i want to display it as ab How to do it ? Thanks.. (1 Reply)
Discussion started by: dhananjaysk
1 Replies
Login or Register to Ask a Question