這個文檔該怎么篩選啊

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'