concat strings

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

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