Thank you all very much for help.
Regards
vimlover
StarWing wrote:
>
>
>
>> 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...
> >
>
>
--
View this message in context:
http://www.nabble.com/How-to-do-this--tp22274905p22276291.html
Sent from the Vim - General mailing list archive at Nabble.com.
--~--~---------~--~----~------------~-------~--~----~
You received this message from the "vim_use" maillist.
For more information, visit http://www.vim.org/maillist.php
-~----------~----~----~----~------~----~------~--~---
