shell 提取指定范围字符串

shawnloong

文件内容如下，只提取从CREATE TRIGGER "KK_ONLINES".到/并且这段包含KW.
--prompt Creating trigger GOODS_TECH_PROP_TRI
--prompt ====================================
--prompt

/

ALTER TRIGGER "GW_ONLINES"."GOODS_TECH_DIR_TRI" ENABLE;

ALTER TRIGGER "GW_ONLINES"."GOODS_TECH_DIR_TRI"
  COMPILE
    PLSQL_OPTIMIZE_LEVEL=  2
    PLSQL_CODE_TYPE=  INTERPRETED    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE'
;
CREATE TRIGGER "KK_ONLINES"."USER_TRI"  BEFORE INSERT ON KW."USER" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW
BEGIN SELECT GW.USER_FEEDBACK_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/

ALTER TRIGGER "GW_ONLINES"."USER_FEEDBACK_TRI" ENABLE;

ALTER TRIGGER "GW_ONLINES"."USER_FEEDBACK_TRI"
  COMPILE
    PLSQL_OPTIMIZE_LEVEL=  2
    PLSQL_CODE_TYPE=  INTERPRETED    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE'
;
CREATE TRIGGER "KK_ONLINES"."BILL_MALL_TRI"  BEFORE INSERT ON "KW01"."BILL_MALL" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW
BEGIN SELECT BILL_SELL_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;

/



ALTER TRIGGER "GW_ONLINES"."USER_ii_TRI" ENABLE;

ALTER TRIGGER "GW_ONLINES"."USER_ii_TRI"
  COMPILE
    PLSQL_OPTIMIZE_LEVEL=  2
    PLSQL_CODE_TYPE=  INTERPRETED    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE'
;
CREATE TRIGGER "KK_ONLINES"."USER_ii_TRI"  BEFORE INSERT ON "KW01"."USER_ii" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW
BEGIN SELECT BILL_SELL_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;

/

songyc_2015

awk '/CREATE TRIGGER "KK_ONLINES"/&&/\<KW/{p=1}p;/\//{p=0}' file

zxy877298415

回复 1# shawnloong

1. awk -v RS='CREATE TRIGGER "KK_ONLINES".'  -F "/" '{if($1~/KW\./) print RT$1}' file

复制代码

shawnloong

回复 3# zxy877298415


    不行。有问题，匹配不了。

shawnloong

回复 2# songyc_2015


    不行啊。匹配不了

yjh777

[yjh@localhost ~]$ sed -n '/^CREATE TRIGGER "KK_ONLINES"\..*KW\./,/^\//p' tmp.txt
CREATE TRIGGER "KK_ONLINES"."USER_TRI"  BEFORE INSERT ON KW."USER" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW
BEGIN SELECT GW.USER_FEEDBACK_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;


/


如果 KW. 跟 CREATE 不在一行，就得写循环了;