Generating a Job to recuperate regular expressions - Cloud - 8.0

Talend Studio User Guide
Version
Cloud
8.0
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
Last publication date
2023-09-26
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

From Profiling perspective of Talend Studio, you can generate an automated Job to recuperate regular expressions from the Internet library http://regexlib.com and write them in a CSV file.

You can then import these regular expressions in Talend Studio through the Import Patterns option.

Before you begin

You have selected the Profiling perspective.

Procedure

  1. In the DQ Repository tree view, expand Libraries > Patterns.
  2. Right-click the Regex folder.
  3. From the contextual menu, select Generate jobs > Get Patterns.

    The Integration perspective opens on the generated Job.

  4. In the workspace, select the tFindRegexlibExpression component to display its Basic settings view.
  5. In the Key Words field, enter the regular expression name you want to recuperate.
  6. If required, click any of the two other components to display the Basic settings view to modify any of the component parameters.
  7. Save the Job and press F6 to execute it.
    A message is displayed to show the progress of the operation.

Results

All specified regular expression are recuperated from the Internet library and written in the CSV file. You can now import the recuperated regular expressions into the Studio by using the Import Patterns option. For more information, see Importing regular expressions or SQL patterns from a CSV file.