Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
.
google site




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 04-22-2006
sendhilmani123 sendhilmani123 is offline
Registered User
 

Join Date: Apr 2006
Posts: 33
Shell scripting and SQL

Hi,

I have a file that has contents like this:
SQL> select * from details;

NAME REG
-------------------- ----------
Mani 1
Santosh 2
Manju 3
Mukesh 4

SQL> spool off;

I want to remove the first line'select * from details' and the last line 'spool off'. I also want to remove the lines 'Name Reg and the line below them' and also introduce a new field seperator between values. How can I do it.
Sponsored Links