From Profiling perspective of Talend Studio, you can generate an automated Job to recuperate regular expressions from the internet library http://regexlib.com and write them in a CSV file.
You can then import these regular expressions in Talend Studio through the Import Patterns option.
Before you begin
You have selected the Profiling perspective of Talend Studio.
In the DQ Repository tree view,
- Right-click the Regex folder.
From the contextual menu, select Generate jobs > Get
The Integration perspective opens on the generated Job.
In the workspace, select the tFindRegexlibExpression
component to display its Basic settings view.
- In the Key Words field, enter the regular expression name you want to recuperate.
- If required, click any of the two other components to display the Basic settings view to modify any of the component parameters.
Save the Job and press F6 to execute
A message is displayed to show the progress of the operation.
All specified regular expression are recuperated from the internet library and written in the CSV file. You can now import the recuperated regular expressions into the studio by using the Import Patterns option. For more information, see Importing regular expressions or SQL patterns from a CSV file.