Importing regular expressions or SQL patterns - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

You can import regular expressions or SQL patterns from Talend Exchange into your Talend Studio and use them on analyses. This way you can share all the patterns created by other users and stored on the exchange server.

You can also import the regular expressions or SQL patterns stored locally in a csv file. The csv file must have specific columns including the ones listed in the table below. The csv file may contain only a few of them.

Column name Description
Label The label of the pattern (must not be empty)
Purpose The purpose of the pattern (can be empty)
Description The description of the pattern (can be empty)
Author The author of the regular expression (can be empty)
Relative Path The relative path to the root folder (can be empty)
All_ DB_Regexp The regular expression applicable to all databases (can be empty)
<database name>_Regexp The regular expression applicable to this specific databases (can be empty)