How to remove unwanted elements from the command line?

Shell Programming and Scripting
1 
CREATE TYPE "SUPERB"."OE_L2_FOOTERDATA_REC"
  OID '1232323232' IS OBJECT
(
  AWLSTrxId          NUMBER,
  AdjPurchaseAmount NUMBER,
  Network           NUMBER,
  ConfigVersion     NUMBER
);
/

I wanted my output to be as follow:

CREATE TYPE OE_L2_FOOTERDATA_REC
  OID '1232323232' IS OBJECT
(
  AWLSTrxId          NUMBER,
  AdjPurchaseAmount NUMBER,
  Network           NUMBER,
  ConfigVersion     NUMBER
);
/

now how do i remove the double quotes and the "SUPERB" from the linux os system command line?

thanks

thanks

2 
sed 's/\"SUPERB\"\.\"\([^\"]*\)\"/\1/' file
1 Like
3 
awk -F"[ .\"]" '/SUPERB/ {print $1,$2,$7} !/SUPERB/ {print $0}' infile
4

thanks for the reply

if the output is

CREATE or replace TYPE OE_L2_FOOTERDATA_REC   OID '1232323232' IS OBJECT (   AWLSTrxId          NUMBER,   AdjPurchaseAmount NUMBER,   Network           NUMBER,   ConfigVersion     NUMBER ); /

how do I do it? thanks

5

How do you do what?

6

how do I change from

CREATE TYPE OE_L2_FOOTERDATA_REC   OID '1232323232' IS OBJECT (   AWLSTrxId          NUMBER,   AdjPurchaseAmount NUMBER,   Network           NUMBER,   ConfigVersion     NUMBER ); /

to

CREATE or replace TYPE OE_L2_FOOTERDATA_REC   OID '1232323232' IS OBJECT (   AWLSTrxId          NUMBER,   AdjPurchaseAmount NUMBER,   Network           NUMBER,   ConfigVersion     NUMBER ); /

i.e
CREATE TYPE OE_L2_FOOTERDATA_REC

to
CREATE or replace TYPE OE_L2_FOOTERDATA_REC

what I mean add ' or replace'

thanks

7 
sed 's/^CREATE/& or replace/'

sed is an excellent tool for such jobs. Take a look at this link.

8

Hi Balajesuri,

i did this in the operating system,

sed 's/^CREATE/& or replace/' fpe_temp_dist_abf_stage2.sql > fpe_temp_dist_abf_stage3.sql

output is still the same, i.e. fpe_temp_dist_abf_stage2.sql is the same as fpe_temp_dist_abf_stage3.sql

CREATE TABLE FPE_TEMP_DIST_ABF                                                                                         
   (    "THREAD_IDX" NUMBER(3,0),                                                                                        
        "DISC_ID" NUMBER(10,0),                                                                                          
         PRIMARY KEY ("THREAD_IDX", "DISC_ID") ENABLE                                                                    
   ) ORGANIZATION INDEX NOCOMPRESS

---------- Post updated at 06:50 PM ---------- Previous update was at 03:13 PM ----------

the output I have after

Code:
sed 's/\"SUPERB\"\.\"\([^\"]*\)\"/\1/' file

                                                                                                    [RIGHT]                                                                                         [[IMG]http://linux.unix.com/images/buttons/quote.gif[/IMG]](http://www.unix.com/newreply.php?do=newreply&p=302771663)                                           [[IMG]http://linux.unix.com/images/buttons/multiquote_off.gif[/IMG]](http://www.unix.com/newreply.php?do=newreply&p=302771663)                                           [[IMG]http://linux.unix.com/images/buttons/quickreply.gif[/IMG]](http://www.unix.com/newreply.php?do=newreply&p=302771663)                                                                                                                                                [/RIGHT]

  CREATE TABLE ACTIVATED_FILLER
   (    "AD_ID" NUMBER(8,0),
        "FAD_ID" NUMBER(8,0),
        "CF_ID" NUMBER(8,0),
        "ACTIVATE_STATUS" NUMBER,
        "LAST_UPDATE_BY" NUMBER(8,0),
        "LAST_UPDATE_DATE" DATE
   )

so how do i remove the quotes for the columns, i.e desired output is

  CREATE TABLE ACTIVATED_FILLER
   (    AD_ID NUMBER(8,0),
        FAD_ID NUMBER(8,0),
        CF_ID NUMBER(8,0),
        ACTIVATE_STATUS NUMBER,
        LAST_UPDATE_BY NUMBER(8,0),
        LAST_UPDATE_DATE DATE
   )

thanks