AskDba.org Weblog

Thought of sharing some useful info which can help you to do your work faster in vi.You can use awk/sed scripts in vi using following command in vi :%!scriptname Here the scriptname file should have execute privilges for user. I used this to create a useful script which I was doing by typing multiple substitution command in vi. e.g Your file contains list of table $cat t.lst BANK005 BJSTM BJS_ORG CHAINED_ROWS CORR_BAM CORR_CAM CORR_EIT CORR_GAC CORR_GAM CORR_ITC CORR_LDT CORR_LHT Create script (quotes)  with following command and give execute permission to user. sed -e “s/^/’/g” -e “s/$/’,/” $1|awk ‘{printf (“%s”,$0)}’|sed -e “s/^/(/g” -e “s/,$/)/g” open t.lst in vi and type :%!quotes ('BANK005','BJSTM','BJS_ORG','CHAINED_ROWS','CORR_BAM','CORR_CAM','CORR_EIT','CORR_GAC','CORR_GAM','CORR_ITC','CORR_LDT','CORR_LHT') Similarly if you wish to remove blank lines, have a file blank like awk ‘!NF==0 {print $0}’ $1 Blank lines can also be directly removed from vi using :g/^$/d Isn’t it cool.. … Read entire article »