Share your regular expressions on Talend Exchange

12 02 2009

A new service is offered on the Talend Forge website. It’s called Talend Exchange and is aimed at providing a place where you can share TOS components, TOS templates, TOS jobs and TOP patterns. It is an enhancement of the previously called “Ecosystem” service.

I have added a few new regular expressions for Talend Open Profiler which may be useful to French users. You may download them and import them in Talend Open Profiler-1.1.x via the “import patterns” menu available on the “Libraries/Patterns” folder.

You may add your own regular expressions too. For the Talend Open Profiler-1.1.x platform, you need to create a simple xls file with the following columns
* C1: Label: the label of the pattern
* C2: Purpose: the purpose of the pattern
* C3: Description: the description of the pattern
* C4: Regular expression: the regular expression applicable to all databases
* C5: MySQL Regexp: the regular expression applicable to MySQL databases
* C6: Oracle Regexp: the regular expression applicable to Oracle databases
* C7: Author: the author of the regular expression
Then compress it in the zip format and you’re ready to upload it on Talend Exchange.

For the current development version of Talend Open Profiler-1.2.0xx, the task is even easier because there is a menu to export your regular patterns and/or your SQL patterns in csv format. For this version, it is suggested to export your patterns individually. Then compress your csv file(s) and upload them on Talend Exchange to share them with other users. The “import” menu will be able to read these files (once unzipped).

We’ll work later on a more integrated mechanism to share your patterns in one click.

Advertisements

Actions

Information

3 responses

5 08 2011
samm

Regular Search Expression for Multiline
^([0-9][0-9]/[0-9][0-9]/[0-9][0-9][0-9][0-9]) +([^ ]+) *([^ ]+) +(……………………………..) +([0-9,.]+) +([0-9,.]+)\n +(……………………………)
Regular Expression for Multiline Replace.
\1|\2|\3|\4\7|\5|\6

Regular Search Expression for Single line
^([0-9][0-9]/[0-9][0-9]/[0-9][0-9][0-9][0-9]) +([^ ]+) *([^ ]+) +(……………………………..) +([0-9,.]+) +([0-9,.]+)$
Regular Expression for Single line Replace.
\1|\2|\3|\4|\5|\6

01/01/2011 CUST101 BILL PAYMENT FOR CREDIT CARD OF HSBC 5,535.00 5,535.53
3534535 636346 3463463 663463

27 06 2012
BG

I am using MS Excel 2010 and I tried to use your existing US Phone Number pattern ,i am getting combability error and also when i try to import it on Regex section i am getting invalid header error and on the preview i see the 2nd line of the csv. Please help!

29 06 2012
scorreia

Please, ask your question on the Talend’s forum http://talendforge.org/forum/viewforum.php?id=12 Someone will help you with this issue.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




%d bloggers like this: