Open Studio for Data Quality
It is possible to test character sequences against a predefined or newly created regular expression.
At least one database connection is set in the Profiling perspective of Talend Studio.
Before you begin
- Follow the steps outlined in Creating a new regular expression or SQL pattern to create a new regular expression.
In the open pattern editor, click Pattern
Definition to open the relevant view.
Click the Test button next to the
definition against which you want to test a character sequence to proceed to
the next step.
The test view is displayed in the Studio showing the selected regular expression.
- In the Test Area, enter the character sequence you want to check against the regular expression
From the DB Connection list, select the
database in which you want to use the regular expression.
Note: If you select to test a regular expression in Java, the Java option will be selected by default and the DB Connections option and list will be unavailable in the test view.
An icon is displayed in the upper left corner of the view to indicate if the character sequence matches or does not match the selected pattern definition.
If required, modify the regular expression according to your needs and
then click Save to save your
The pattern definition is modified accordingly in the pattern editor.