Entering Java regular expressions in filter fields


The following Java regular expression items can be used in the object filter fields for Creator/Schema and Table/DSN and the relationship filter fields for Parent/creator schema, Parent Table/DSN, Dependent Creator/Schema, Dependent Table/DSN, and Relationship Name:

.

Dot, any character (may or may not match line terminators, read on)

\d

A digit: [0-9]

\D

A non-digit: [^0-9]

\s

A whitespace character: [ \t\n\x0B\f\r]

\S

A non-whitespace character: [^\s]

\w

A word character: [a-zA-Z_0-9]

\W

A non-word character: [^\w]



*

Match 0 or more times

+

Match 1 or more times

?

Match 1 or 0 times

{n}

Match exactly n times

{n, }

Match at least n times

{n,m}

Match at least n but not more than m times


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*