Exporting regular expressions or SQL patterns to a CSV file - 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
2024-02-22
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

Before you begin

You have selected the Profiling perspective.

Procedure

  1. In the DQ Repository tree view, expand Libraries > Patterns, and then right-click Regex.
  2. From the contextual menu, select Export Patterns.

    The Export Patterns wizard opens.

    Overview of the Export Pattern wizard.
  3. Browse to the CSV file where to save the regular expressions.
  4. Click Select All to select all listed regular expressions or select the check boxes of the regular expressions you want to export.
  5. Click Finish to close the wizard.
    When users try to import these regular expressions from the CSV file into the repository of Talend Studio, the regular expressions will be imported under the Regex folder, and thus have the same path in the new repository.
    All exported regular expressions are saved in the defined CSV file.

What to do next

To export a single regular expression family to a CSV file, do the following:

  1. In the DQ Repository tree view, expand Libraries > Patterns, and browse to the regular expression family you want to export.
  2. Right-click it and select Export Patterns.

    The Export Patterns wizard opens.

  3. Click Select All to select all the check boxes of the regular expressions or select the check boxes of the regular expressions you want to export to the CSV file.
  4. Click Finish to close the wizard.

    All exported regular expressions are saved in the defined CSV file.

When users try to import these regular expressions from the CSV file into the repository of Talend Studio, the regular expressions will be imported under the same subfolder, and thus have in the new repository the same path they had in the initial repository.