Exporting regular expressions or SQL patterns to a csv file - 7.1

Talend Data Management Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Data Management Platform
task
Design and Development
EnrichPlatform
Talend Studio

Before you begin

Prerequisite(s): You have selected the Profiling perspective in the studio.

To export regular expressions to a csv file, do the following:

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 then browse to the regular expression family you want to export.
  2. From the contextual menu, 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.