tag:blogger.com,1999:blog-6266231010760265271.post1197326901471355654..comments2024-03-28T05:23:13.144-04:00Comments on Bekwam Blog: The Regex Lookup Table with Talend Open StudioCarlhttp://www.blogger.com/profile/15013889141640529637noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-6266231010760265271.post-42399157521974642312011-12-20T16:31:13.117-05:002011-12-20T16:31:13.117-05:00Great! Thanks.Great! Thanks.Anonymoushttps://www.blogger.com/profile/07756830537136925187noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-24369508803692381782011-12-20T13:52:43.249-05:002011-12-20T13:52:43.249-05:00The logic in the for loop from the code in "S...The logic in the for loop from the code in "Subjob 3 Load the Data" can be as complex as needed. Here it's doing a straightforward regex matches() on a single column.<br /><br />If you need a lot more flexibility, consider storing a dynamic expression in the spreadsheet. For example, if you need to establish a match between varying numbers of columns.<br /><br />This post uses Jexl (Javascript) in Talend to form such expressions.<br /><br />http://bekwam.blogspot.com/2011/04/embedding-expressions-with-jexl-in.html<br /><br />Good luck!Carlhttps://www.blogger.com/profile/15013889141640529637noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-29053999515971320212011-12-20T13:44:44.945-05:002011-12-20T13:44:44.945-05:00This is really awesome...Thanks a lot for posting ...This is really awesome...Thanks a lot for posting this. I'm going to give this a try....I have a fairly complicated data flow and I'll be using this technique to do a conditional replace. I wish replacelist had conditional elements in it.Anonymoushttps://www.blogger.com/profile/07756830537136925187noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-29657064518912051792011-04-11T17:37:06.981-04:002011-04-11T17:37:06.981-04:00Hi Evando,
I'm glad you found it useful.
-Ca...Hi Evando,<br /><br />I'm glad you found it useful.<br /><br />-CarlCarlhttps://www.blogger.com/profile/15013889141640529637noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-68756155295141787062011-04-11T17:10:27.338-04:002011-04-11T17:10:27.338-04:00Congratulations Carl for the article. It was very ...Congratulations Carl for the article. It was very useful to me<br />Thanks.<br /><br />Evando.Evandohttps://www.blogger.com/profile/11459338277302044570noreply@blogger.com