The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Reload this Page removing pattern which is spread in multiple lines
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read



Thread: removing pattern which is spread in multiple lines
View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 05-12-2008
sabyasm sabyasm is offline
Registered User
  
 

Join Date: Sep 2005
Posts: 27
Exclamation removing pattern which is spread in multiple lines
I have several huge files wich contains oracle table creation scripts as follows:
Quote:
CREATE TABLE PROD_MST.PROD_DEF_ALLOWED_RESELLERS (
PROD_DEF_ALLOWED_RESELR_ID NUMBER NOT NULL,
SRVC_PROVIDER_ID NUMBER NOT NULL,
CREATED_BY VARCHAR2(40 BYTE) NOT NULL,
CREATED_DTIME DATE NOT NULL,
LAST_UPDATED_BY VARCHAR2(40 BYTE) NOT NULL,
LAST_UPDATED_DTIME DATE NOT NULL,
PROD_ID NUMBER NOT NULL
)
PCTFREE 10
PCTUSED 0
INITRANS 1
MAXTRANS 255
TABLESPACE CUST_MASTER_DATA
STORAGE (
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
BUFFER_POOL DEFAULT
)
LOGGING
;


CREATE TABLE PROD_MST.PROD_DEFINITION (
PROD_ID NUMBER NOT NULL,
PROD_NAME VARCHAR2(100 BYTE) NULL,
PROD_STATUS VARCHAR2(20 BYTE) NULL,
PROD_CODE VARCHAR2(40 BYTE) NULL,
PROD_CODE_TYPE VARCHAR2(40 BYTE) NULL,
PROD_EFFECTIVE_START_DATE DATE NULL,
PROD_EFFECTIVE_END_DATE DATE NULL,
SRVC_PROVIDER_ID NUMBER NOT NULL,
CREATED_BY VARCHAR2(40 BYTE) NOT NULL,
CREATED_DTIME DATE NOT NULL,
LAST_UPDATED_BY VARCHAR2(40 BYTE) NOT NULL,
LAST_UPDATED_DTIME DATE NOT NULL
)
PCTFREE 10
PCTUSED 0
INITRANS 1
MAXTRANS 255
TABLESPACE PROD_MASTER_DATA
STORAGE (
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
BUFFER_POOL DEFAULT
)
LOGGING
;
.....
and so on
I would need to remove the pattern colored in red above. Any sed/awk/pearl code will be of much help.

Thanks