> I have hundreds of rows in a files like:
>
> ALTER TABLE "PCDTST"."ACCOUNTINGSTATUS" ADD CONSTRAINT
> "PK_ACCOUNTINGSTATUS" PRIMARY KEY ("ACCOUNTINGSTATUS") USING INDEX PCTFREE
> 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST
> GROUPS 1) TABLESPACE "PESDBO_INDEXES" LOGGING ENABLE ;
>
> how can I change to: (just delet 'USING' clause till ';' in each line)
>
> ALTER TABLE "PCDTST"."ACCOUNTINGSTATUS" ADD CONSTRAINT
> "PK_ACCOUNTINGSTATUS" PRIMARY KEY ("ACCOUNTINGSTATUS");
maybe
:%s/USING \zs[^;]\ze;//g
or
:%s/USING \zs.\{-}\ze\s*;\s*$//g
you can choose one for try...
--~--~---------~--~----~------------~-------~--~----~
You received this message from the "vim_use" maillist.
For more information, visit http://www.vim.org/maillist.php
-~----------~----~----~----~------~----~------~--~---
