Chinaunix

标题: 為什麽我的這個用AWK處理有問題 [打印本页]

作者: mir620 时间: 2011-06-20 15:25
标题: 為什麽我的這個用AWK處理有問題
文件synonym.sql的內容如下
create synonym "informix".azf_file for hfj1dt6:"roger".azf_file;
create synonym "itp17299".bti_file for hfjlh1:"itp17299".bti_file;
create synonym "itz3028".aaz_file for hfj1dt6:"roger".aaz_file;
create synonym "itz3028".aaa_file for hfj1dt6:"roger".aaa_file;
create synonym "informix".pmoo_file for hfj1dt6:"informix".pmoo_file;
create synonym "informix".aag_file for hfjlh0_share:"roger".aag_file;
create synonym "itp17299".kxf_file for hfjlh1:"tiptop".kxf_file;
create synonym "informix".ate_file for hfjlh1:"itz0882".ate_file;
create synonym "informix".zw_tri_file for ds:"informix".zw_tri_file;
create synonym "informix".zy_tri_file for ds:"informix".zy_tri_file;
create synonym "informix".bqe_file for hfjlh1:"informix".bqe_file;
create synonym "informix".bwp_file for hfjlh1:"informix".bwp_file;
create synonym "informix".oab_file for hfj1dt6:"danny".oab_file;
create synonym "informix".oag_file for hfjlh0_share:"danny".oag_file;
create synonym "informix".azic_file for hfjlh1:"itp17299".azic_file;
create synonym "informix".pmb_file for hfj1dt6:"informix".pmb_file;
create synonym "informix".pmct_file for hfjlh0_share:"itz0882".pmct_file;
create synonym "informix".asff_file for hfj1dt6:"informix".azff_file;
create synonym "informix".azff_file for hfj1dt6:"informix".azff_file;
create synonym "informix".aav_file for hfjlh1:"itz0882".aav_file;
create synonym "informix".azn_file for hfj1apd:"roger".azn_file;
create synonym "informix".zudd_file for hfj1dt6:"informix".zudd_file;
create synonym "informix".apz_file for hfjlh1:"roger".apz_file;
create synonym "informix".upd_tri_file for hfj1asd2:"informix".upd_tri_file;
create synonym "informix".atm_file for hfj1dt6:"informix".atm_file;
create synonym "informix".ato_file for hfj1dt6:"informix".ato_file;
create synonym "informix".atp_file for hfj1dt6:"informix".atp_file;
create synonym "informix".occo_file for hfjlh1:"itz0882".occo_file;
create synonym "itz3028".zwa_file for ds:"itz3028".zwa_file;
怎樣將每一行的庫名后面加_cost_10
如create synonym "informix".occo_file for hfjlh1:"itz0882".occo_file;
換成create synonym "informix".occo_file for hfjlh1_cost_10:"itz0882".occo_file;

我用awk -F '[ :]+' '{print $1,$2,$3,$4,$5=$5_cost_10,$6}' synonym.sql
為什麽不可以

作者: mir620 时间: 2011-06-20 15:28
我知道了
awk -F '[ :]+' '{print $1,$2,$3,$4,$5=$5"cost_10:",$6}' syn.sql
這樣就可以了，但是我還是感覺有點不對
有沒有其他的寫法

作者: wtuter 时间: 2011-06-20 15:44
回复 1# mir620

sed -r 's/(.* )(.*):/ \1\2_cost_10/'

作者: greysky-zfj 时间: 2011-06-20 15:47
awk -F ':' '{print $1“_cost_10：”$2}' syn.sql

作者: ly5066113 时间: 2011-06-20 16:08
awk -F: -v OFS=: '$1=$1"_cost_10"' syn.sql
sed 's/:/_cost_10&/' syn.sql

作者: spouter 时间: 2011-06-20 16:38
回复 5# ly5066113

不错！

作者: justlooks 时间: 2011-06-20 17:31

awk 'BEGIN{FS=":";OFS=":";}{$1=$1"_cost_10";}1'

复制代码

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)