Skip to main content Skip to complementary content

Exporting regular expressions or SQL patterns to a CSV file

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here