Testing a regular expression in the Pattern Test View

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.

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 Talend 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.

Information noteNote: 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.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!