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 'S' OPTION on. It is not picking up ([A-Z|_]*)([^;]*;).
Do you think this is a bug?
RegEx Engine not working correctly?
Re: RegEx Engine not working correctly?
There are a lot of excessive places in your regular expressions.
Try the following simpler expression:
Search for:
PCTFREE.*(TABLESPACE \S+)\s+.*;
Replace with:
$1;
Try the following simpler expression:
Search for:
PCTFREE.*(TABLESPACE \S+)\s+.*;
Replace with:
$1;
-
- Posts: 2
- Joined: Mon Jun 01, 2009 6:48 pm
Re: RegEx Engine not working correctly?
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 used the more basic character classes, i.e. [a-z|_], as a last resort to try and de-bug the regex engine. I still think there is a bug and a ticket should be opened.
Let me know what you think.
Thanks
Let me know what you think.
Thanks