String replacement using Regualr expressions

[KP]

TABLESPACE mv_tsstat_storage_clause_for_ALERT_NOTE_RECIPIENTS

need to replace any occurance of the line with

TABLESPACE mv_tsstat

The last portion after the _storage_clause_for_(can be any characters or strings)


HELP

[s_reynisson]

Using Regular Expression:
Find (TABLESPACE mv_tsstat)_storage_clause_for_[^X]*
Replace \1
Where X=Space
I have used POSIX regular expression syntax, which can be selected
from the Editor page of the Preferences dialog box.
Edit A more general form would be (TABLESPACE [^X]+)_storage_clause_for_[^X]*