Hy,

i have the follwing code:

1 ALTER TABLE KEN123 ADD ...;
2 CREATE UNIQUE INDEX UKEN123_BEZ ON KEN123(BEZ)...;
3 CREATE INDEX IKEN123_FK ON KEN123(FK)...;
4 ... some other code ...

I want to find the lines 2, 3 with the regular expression
create *[a-zA-Z ]* INDEX
In my "normal" Editor (WinVi) this expression works, but PSD don't find anything? (wether the SearchBar nor the Find&Replace Dialog)

Could you please help me?

You need to use \s for a whitespace character:

CREATE[a-zA-Z\s]*INDEX

Thanks.

It is a little be wired, because with your regular expression my "normal" Editor finds nothing ;-)

Is PSD using all the standard charclasses like
\d for a digit or \w for [a-zA-Z_0-9]?

Yes:

\t The tab character
\n The newline character
\r The return character
\f The formfeed character
\b The backspace character
\xNN The hex character NN
\0ooo The octal character ooo
\w A single character, one of [a-zA-Z0-9_]
\W Any single character not matching \w
\d A single character [0-9]
\D A single character not matching \d
\s A whitespace character [\t\r\n\f\b\ ]
\S A single character not matching \s

Is this mentioned somewhere in the documentation?
If not, please add this info.

I just RTFM, but alas, I didn't found it.

Roeland

PS: PL/SQL Developer 9.0
Users Guide
April 2011

A documentation of this feature is a must!!! RegEx are so powerful, but without any documentation they are nearly impossible to use :-(
There are too many nuances around, so it is very important to have some kind of documentation about what is supported and what not.
Especially, if one tries to a search/replace with a RegEx...