Testing a regular expression in the Pattern Test View - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
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

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

  1. Follow the steps outlined in Creating a new regular expression or SQL pattern to create a new regular expression.
  2. In the open pattern editor, click Pattern Definition to open the relevant view.
  3. 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.
  4. In the Test Area, enter the character sequence you want to check against the regular expression
  5. 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.
  6. 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.
  7. 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.