Abacre.com

Thank you for your help and quick relpy. Your code worked. However, my code should work as well. I tried at least 20 combinations of metacharacters, all of which should have worked. I started out with an expression with only one capturing block, but the regex engine did not like that either. I only ...

Source Text:
PCTFREE 10
INITRANS 1
STORAGE
(
INITIAL 80K
NEXT 1024K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
)
TABLESPACE MCPPD_DATA
NOLOGGING
MONITORING
NOPARALLEL;

Match Pattern:
(PCTFREE.*)(TABLESPACE )([A-Z|_]*)([^;]*;)
Replace Pattern:
$2$3;

Expected Results:
TABLESPACE MCPPD_DATA;

I have the ...