文本处理，日志文件切割

changsiheng

请教一下各位，我想将delete,update,insert行匹配留下来，其他行删除

并且把匹配行中的用户和表提出，最后效果是

OSU_DEPLOY"."TBL_OSU_PRODUCTFILTER_I"

USERINFOV2"."TBL_USERSERVICELOCATION

AVUSER"."TBL_AV_USERPUSH_H




delete    from "OSU_DEPLOY"."TBL_OSU_PRODUCTFILTER_I" t where
rownum = 1  and "PRFI_ID"='72814642' and "PRFI_BUSIID_FK"=
'101' and "PRFI_COOPID_FK"='-01' and "PRFI_NVINID_FK"='0141' and
"PRFI_MCNC_FK"='46002' and "PRFI_PRINID_FK"='6' and "PRFI_CPINID_FK"=
'-01' and "PRFI_USERTYPE"='-01' and "PRFI_PRIORITY"='31' and "PRFI_PLFOID_FK"=
'-01' and "PRFI_PRSEID_FK"='0263' and "PRFI_FREETACTIC_SWITCH"=
'0' and "PRFI_INAPPSUPPORT" is null and "PRFI_FLAG"='02' and "PRFI_MCC_FK"=
'460' and "PRFI_PRDUIDS_FK"='870' and "PRFI_NEEDMOBILENUM" is
null RETURNING ROWID INTO :RID;

update   "USERINFOV2"."TBL_USERSERVICELOCATION" t set "USSL_LATESTDATE"=
'05012014133129' where rownum = 1 and "USSL_UID"='A731684562'
and "USSL_BUSIID_FK"='101' and "USSL_LATESTDATE"='0423201411'||
'0808';

insert into "AVUSER"."TBL_AV_USERPUSH_H" ("USPU_ID","USPU_UID_FK"
,"USPU_PUSHDATE","USPU_TS") values ('0534467460','1088281486'
,'09062014190946','4');


还请帮忙指点一下

hjfeng1988

1. awk '/delete/||/insert/{print $3};/update/{print $2}' file

复制代码

tuyajie

1. [jay.liu@aliCloud ~]$ grep "delete\|insert\|update" test.txt | cut -d"\"" -f2-4
   
2. OSU_DEPLOY"."TBL_OSU_PRODUCTFILTER_I
   
3. USERINFOV2"."TBL_USERSERVICELOCATION
   
4. AVUSER"."TBL_AV_USERPUSH_H

复制代码

我的结果更像一点。

changsiheng

回复 2# hjfeng1988


    感谢！学习了！

changsiheng

回复 3# tuyajie


    非常感谢

moperyblue

1. grep -oP '"[^"]*"\."[^"]*"'

复制代码

sunzhiguolu

1. perl -nle 'print $1 if(m/\A(?:delete|update|insert)(?:\s*(?:from|into|))\s*"(\S+)"/i)' f

复制代码