Before you begin
In the Profiling perspective of Talend Studio, a column analysis is created on a date column using the Date Pattern Frequency indicator.
For more information on how to create a column analysis, see Creating a basic analysis on a database column.
- In the DQ Repository tree view, right-click the column analysis that uses the date indicator on a date column.
Select Open from the contextual menu to open the
corresponding analysis editor.
Press F6 to execute the analysis and display the
analysis results in the Analysis Results view of the
In this example, 100.00% of the date values follow the pattern
yyyy MM ddand 39.41% follow the pattern
yyyy dd MM.
Right-click the date value for which you want to generate a regular expression
and select Generate Regex Pattern from the contextual
The New Regex Pattern dialog box is displayed.
The date regular expression is already defined in the corresponding field.
Click Finish to proceed to the next step.
The pattern editor opens with the defined metadata and the generated pattern definition.The new regular expression is listed under DQ Repository tree view. You can drag it onto any date column in the analysis editor.in the
- Optional: If required, click the Test button to test a character sequence against this date regular expression as outlined in Testing a regular expression in the Pattern Test View.