Available in...Big Data Platform
Cloud API Services Platform
Cloud Big Data Platform
Cloud Data Fabric
Cloud Data Management Platform
Data Fabric
Data Management Platform
Data Services Platform
MDM Platform
Real-Time Big Data Platform
Procedure
-
In the DQ Repository tree view,
expand .
-
Right-click Regex and select
Import patterns.
The Import Patterns wizard opens.
-
Browse to the csv file holding the regular expressions.
-
In the Duplicate patterns handling
area, select:
Option |
Description |
skip existing patterns
|
Import only the regular expressions that do not exist in the
corresponding lists in the DQ Repository tree
view. A warning message is displayed if the imported patterns already
exist under the Patterns folder. |
rename new patterns with suffix
|
Identify each of the imported regular expressions with a suffix. All
regular expression will be imported even if they already exist under the
Patterns folder. |
-
Click Finish.
A confirmation message is displayed.
-
Click OK.
All imported regular expressions are listed under the
Regex folder in the DQ
Repository tree view.
Results
The regular expressions are imported under the same folders or subfolders they had in
the initial repository.
Important: A warning icon

next to the name of
the imported regular expression or SQL pattern in the tree view identifies that it is
not correct. You must open the expression or the pattern and try to figure out what is
wrong. Usually, problems come from missing quotes. Check your regular expressions and
SQL patterns and ensure that they are encapsulated in single quotes.