The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > OS Specific Forums > Linux
Reload this Page sed to fix view names
Google UNIX.COM
Forums Portal Register Rules & FAQContribute Members List Arcade Search Today's Posts Mark Forums Read



Thread: sed to fix view names
View Single Post in UNIX Forums - Click on the Thread or Permalink to View Entire Thread -->
  #4 (permalink)  
Old 05-14-2008
Franklin52 Franklin52 is offline
Moderator
  

Join Date: Feb 2007
Posts: 1,665
Try this:

Code:
sed '/^create view/s/\(.*\.\)\(.*\)/\1VW_\2/' file > newfile
Regards
Reply With Quote