这个文档该怎么筛选啊

solomhu

某文档内容如下：
TABLE APPROVAL_STAGE LASTACTIONUSERID NUMBER(10) DEFAULT NULL NULL
TABLE ARCHIVE_PROJECT_CONFIG WHERECONDITION VARCHAR2(256) DEFAULT 'D.JOBID=J.JOBID ' NOT NULL
TABLE COMPANY_HK DUNS_NUMBER NUMBER(15,0) NULL
TABLE COMPANY_TW DUNS_NO NUMBER(15,0) NULL
TABLE PARTY_MEMBER USERTYPE VARCHAR2(11) NULL
TABLE PRODUCT_VERSION_CI BOM CLOB(4000) NULL
TABLE PRODUCT_VERSION_TAG DETAIL CLOB(4000) NULL
TABLE RESOURCES_PROP VALUESTR NVARCHAR2(3800) NULL
VIEW ACTIONS_WITH_RISK_ISSUE_V JOBID NUMBER(10) NOT NULL
VIEW ACTIONS_WITH_RISK_ISSUE_V OWNERID NUMBER(10) NOT NULL
VIEW ACTIONS_WITH_RISK_ISSUE_V OWNERTYPE NVARCHAR2(64) NOT NULL
VIEW BMO_JOB_VIEW ISOUTSOURCING NUMBER(10) NOT NULL
VIEW BUDGET_VIEW ACTUALAMOUNT NUMBER(15,2) NOT NULL
VIEW BUDGET_VIEW APPRAMOUNT NUMBER(38,12) NOT NULL
VIEW BUDGET_VIEW ESTIMATEAMOUNT NUMBER(15,2) NOT NULL
VIEW BUDGET_VIEW PARENTBACTUALID NUMBER(10) NOT NULL
VIEW BUDGET_VIEW PARENTBUDGETID NUMBER(10) NOT NULL
VIEW BUDGET_VIEW RESERVEAMOUNT NUMBER(38,12) NOT NULL
VIEW BUDGET_VIEW TARGETAMOUNT NUMBER(38,12) NOT NULL
VIEW CAMPAIGN_ACTUALNUM_V ACTUALNUM NUMBER(10) NOT NULL
VIEW CAMPAIGN_REVENUE_V DEALAMOUNT NUMBER(38,9) NOT NULL
VIEW CAMPAIGN_REVENUE_V DEALAMOUNT2 NUMBER(38,9) NOT NULL
VIEW CAMPAIGN_REVENUE_V ORDERAMOUNT NUMBER(38,9) NOT NULL
VIEW CAMPAIGN_REVENUE_V ORDERAMOUNT2 NUMBER(38,9) NOT NULL
VIEW CHANGE_ORDER_V AGE NUMBER(10) NOT NULL
VIEW CO_FIELD_VIEW COFIELDVID VARCHAR2(61) NOT NULL
VIEW CO_LOG_V COMMENTTYPEID NUMBER(10) NOT NULL
VIEW CO_LOG_V FIELDID NUMBER(10) NOT NULL

我想把句首为"VIEW"所在行的括号内的内容全部删除，句首不是"VIEW"所在行的内容不变，这个应该怎么筛选啊？
我写了一句为:

1. cat file | grep -i '^VIEW\>' | sed 's/(.*)//g'

复制代码

但是这个会把不是VIEW开头的行全部删除，所以无法达到我想要的效果，请帮忙看看有没有比较简单的方式可以达到我想要的效果，谢谢。

Celinde

sed '/^VIEW/s/(.*)/()/'  file

solomhu

thank you!
我还用条件语句去判断它

lizhuohua

sed '/^VIEW/s/\(\d+,?\d+\)/\(\)/g'

freecr_cu

sed '/^VIEW/{s/([0-9,]\+)/()/}' file
or
sed 's/\(^VIEW.*(\).*\().*\)/\1\2/' file

where27

awk -F'[()]' '/^VIEW/{sub($2,"")}1' file

w80286

各位，看看我的这个怎么样：

[root@w80286localdomain shellstudy]# cat d.txt
TABLE APPROVAL
TABLE COMPANY
VIEW ACTIONS
VIEW BUDGET
[root@w80286localdomain shellstudy]# sed '/^VIEW/d' d.txt
TABLE APPROVAL
TABLE COMPANY

where27

回复 7# w80286


    答非所问。。

mgqw

sed '/^VIEW/s#(.*)#()#' c.tmp

lizhuohua

sed '/^VIEW/s/([0-9]*\,\?[0-9]*)/()/g'