Urgent! Sed/Awk Filter Find Pattern Delete Till End Of Line

Shell Programming and Scripting
1

Hi,

I need help with using an awk or sed filter on the below line

ALTER TABLE "ACCOUNT" ADD CONSTRAINT "ACCOUNT_PK" PRIMARY KEY ("ACCT_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "WMC_DATA" LOGGING ENABLE

Look for Pattern "USING" from above and remove from matched pattern till the end of line.

Desired Output

ALTER TABLE "ACCOUNT" ADD CONSTRAINT "ACCOUNT_PK" PRIMARY KEY ("ACCT_ID")

Quick responses appreciated

Thanks,
Rajan

2

Duplicate Post : Urgent Help required : awk/sed help to find pattern and delete till end of line

3

Please read Rule #4 of the UNIX Forums