Articles Comments

AskDba.org Weblog » Unix » Use awk/sed in vi

Use awk/sed in vi

July 2nd, 2009 | 3 Comments

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.. :)
  • Share/Bookmark

Written by Amit

Filed under: Unix · Tags: , ,

3 Responses to "Use awk/sed in vi"

  1. Chris Neumueller says:
    July 2, 2009 at 5:52 pm

    Hi!

    It’s a very useful feature to pipe contents of a vi buffer through some unix command. However, vi has powerful text editing commands that nearly equal sed. The command

    :%s/.*/’&’/ | 1,$-1s/$/,/ | %j! | 1s/.*/(&)/

    does about the same as our quotes script. You can register it as an ex command with

    :command Quotes %s/.*/’&’/ | 1,$-1s/$/,/ | %j! | 1s/.*/(&)/

    and execute it with

    :Quotes

    though this probably only makes sense if you store it in your local .vimrc.

    Reply
  2. Amit says:
    July 2, 2009 at 6:21 pm

    Hi Chris,

    Thanks ..It is very cool..I have not seen few of commands like %j!..I would say i really needed it..

    Cheers
    Amit

    Reply
  3. Amit says:
    July 7, 2009 at 11:48 am

    Command :%j! is very useful as it can be used to format the output given by V$SQLTEXT 

     select sql_text from V$SQLTEXT where sql_id='avv9twxrav4gk' order by piece

SQL_TEXT
----------------------------------------------------------------
select decode(bitand(a.flags, 16384), 0, a.next_run_date,
         a.last_enabled_time),         a.obj#, decode(bitand(a.f
lags, 16384), 0, 0, 1)  from sys.scheduler$_job a  where bitand(
a.job_status, 3) = 1    and ((bitand(a.flags, 134217728 + 268435
456) = 0) or         (bitand(a.job_status, 1024)  0))    and b
itand(a.flags, 4096) = 0    and (a.class_oid is null      or (a.
class_oid is not null      and a.class_oid in (select b.obj# fro
m sys.scheduler$_class b                          where b.affini
ty is null)))    and decode(bitand(a.flags, 16384), 0, a.next_ru
n_date,               a.last_enabled_time) =  (select min(decode
(bitand(c.flags, 16384), 0, c.next_run_date,             c.last_
enabled_time))   from sys.scheduler$_job c   where bitand(c.job_
status, 3) = 1     and ((bitand(c.flags, 134217728 + 268435456)
= 0) or          (bitand(c.job_status, 1024)  0))     and bita
nd(c.flags, 4096) = 0     and (c.class_oid is null       or (c.c
lass_oid is not null       and c.class_oid in (select d.obj# fro
m sys.scheduler$_class d                           where d.affin
ity is null))))

    When you use :%j! it will join line and remove space.

    select decode(bitand(a.flags, 16384), 0, a.next_run_date,         a.last_enabled_time),         a.obj#, decode(bitand(a.flags
, 16384), 0, 0, 1)  from sys.scheduler$_job a  where bitand(a.job_status, 3) = 1    and ((bitand(a.flags, 134217728 + 2684354
56) = 0) or         (bitand(a.job_status, 1024)  0))    and bitand(a.flags, 4096) = 0    and (a.class_oid is null      or (
a.class_oid is not null      and a.class_oid in (select b.obj# from sys.scheduler$_class b                          where b.a
ffinity is null)))    and decode(bitand(a.flags, 16384), 0, a.next_run_date,               a.last_enabled_time) =  (select mi
n(decode(bitand(c.flags, 16384), 0, c.next_run_date,             c.last_enabled_time))   from sys.scheduler$_job c   where bi
tand(c.job_status, 3) = 1     and ((bitand(c.flags, 134217728 + 268435456)= 0) or          (bitand(c.job_status, 1024)  0))
     and bitand(c.flags, 4096) = 0     and (c.class_oid is null       or (c.class_oid is not null       and c.class_oid in (s
elect d.obj# from sys.scheduler$_class d                           where d.affinity is null))))
    Reply

Leave a Reply