Importing regular expressions or SQL patterns from a csv file

Before you begin

You have selected the Profiling perspective of Talend Studio.

Procedure

In the DQ Repository tree view, expand Libraries > Patterns.
Right-click Regex and select Import patterns.

The Import Patterns wizard opens.
Browse to the csv file holding the regular expressions.

In the Duplicate patterns handling area, select:

Option	Description
skip existing patterns	Import only the regular expressions that do not exist in the corresponding lists in the DQ Repository tree view. A warning message is displayed if the imported patterns already exist under the Patterns folder.
rename new patterns with suffix	Identify each of the imported regular expressions with a suffix. All regular expression will be imported even if they already exist under the Patterns folder.

Click Finish.
A confirmation message is displayed.
Click OK.
All imported regular expressions are listed under the Regex folder in the DQ Repository tree view.

Results

The regular expressions are imported under the same folders or subfolders they had in the initial repository.

Note: A warning icon

next to the name of the imported regular expression or SQL pattern in the tree view identifies that it is not correct. You must open the expression or the pattern and try to figure out what is wrong. Usually, problems come from missing quotes. Check your regular expressions and SQL patterns and ensure that they are encapsulated in single quotes.

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