It is possible to test character sequences against a predefined or newly created
regular expression.
Before you begin
At least one database connection is set in the
Profiling
perspective of
Talend Studio.
Procedure
-
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.
-
Click Test.
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
modifications.
The pattern definition is modified accordingly in the pattern
editor.
