Exporting regular expressions or SQL patterns to a CSV file - 7.3

Talend Open Studio User Guide
Version
7.3
Language
English
Product
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Module
Talend Studio
Content
Design and Development
Last publication date
2023-10-11
Available in...

Open Studio for Data Quality

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.

  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 to the CSV file.
  5. Click Finish to close the wizard.
    When users try to import these regular expressions from the CSV file into the repository of their Studios, 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 their Studios, 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.