You can open the editor of any regular expression or SQL pattern to check its
settings and/or edit its definition in order to adapt it to a specific database type, or
adapt it to a specific use.
Before you begin
You have selected the
Profiling
perspective.
Procedure
-
In the DQ Repository tree view,
expand .
-
Browse through the regular expression or SQL pattern lists to reach the
expression or pattern you want to open/edit.
-
Right-click its name and select Open from the contextual
menu.
The pattern editor opens displaying the regular expression or SQL pattern
settings.
-
Modify the pattern metadata, if required, and then click Pattern
Definition to display the relevant view.
In this view, you can: edit pattern definition, change the selected database
and add other patterns specific to available databases through the
[+] button.
Note:
For the PostgreSQL database, regular expressions are not compatible among the database
different versions.
If you want to use the regular expression with PostgreSQL version 9.1 or
greater, you must either:
- in the PostgreSQL database configuration, set the
standard_conforming_strings parameter to
off and write double
backslashes in the definition, or
- in the Regular
expression field in the wizard, use a single backslash in
the expression definition.
For further information about PostgreSQL regular expressions, select , expand Help and then select
Bookmarks.
-
If the regular expression or SQL pattern is simple enough to be used in all
databases, select
Default in the list.
-
Click the save icon on top of the editor to save your changes.
Note: When you edit a regular expression or an SQL pattern, make
sure that your modifications are suitable for all the analyses that may be
using this regular expression or SQL pattern.