The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Reload this Page Include Line Before Pattern Using Sed / Awk
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read



Thread: Include Line Before Pattern Using Sed / Awk
View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #2 (permalink)  
Old 04-22-2009
devtakh devtakh is offline
Registered User
  
 

Join Date: Oct 2007
Location: Bangalore
Posts: 514
try this

sed -e 's/\(CREATE TYPE \([^ ]*\) .*$\)/DROP TYPE \2 FORCE\n\1/g' -e 's/\(CREATE OR REPLACE TYPE \([^ ]*\) .*$\)/DROP TYPE \2 FORCE \n\1/g' Test.sql


cheers,
Devaraj Takhellambam