topic How to use REGEX in tJava(row,flex) in Talend Studio

How to use REGEX in tJava(row,flex)

Anonymous — Thu, 19 Apr 2018 17:57:07 GMT

I have hit a wall using tExtractRegexFields, namely positive lookahead, which does not appear to be in this list, so it appears I cannot use that component. Let's start simple. How would I use a simple regex to match something from a column in a tFileInputDelimited and cat it to a tLogRow?

Re: How to use REGEX in tJava(row,flex)

cterenzi — Thu, 19 Apr 2018 19:50:39 GMT

tExtractRegexFields should support any regex supported by Java's Pattern class.

Re: How to use REGEX in tJava(row,flex)

Anonymous — Thu, 19 Apr 2018 21:47:16 GMT

If I use

(?<=myvalue:)[0-9]*

on data

blah () ; blah, {} words myvalue:42 more data [] 23

in jEdit or elsewhere, it matches "42". Talend is not giving me a match.

regex_match.PNG

Re: How to use REGEX in tJava(row,flex)

Anonymous — Thu, 19 Apr 2018 22:09:30 GMT

Also, if I attempt to match data inside brackets in Talend I am met with an "Invalid escape sequence.." error. This works elsewhere. Please see screenshots.

Re: How to use REGEX in tJava(row,flex)

Anonymous — Thu, 19 Apr 2018 22:40:02 GMT

If it is known why these are not working any help would be appreciated. As per the OP, if it is known how to use REGEX in a tJavawhatever component, that information would be greatly appreciated.

Re: How to use REGEX in tJava(row,flex)

Anonymous — Fri, 20 Apr 2018 17:19:19 GMT

bump

Re: How to use REGEX in tJava(row,flex)

crt1 — Mon, 23 Apr 2018 16:44:02 GMT

It works fine with Pattern and Matcher within a tJavaRow component.

I used tRowGenerator to generate one row with your string:

blah () ; blah, {} words myvalue:42 more data [] 23

In the tJavaRow, aside from the input and output row code I used the following code as a very rough example:

Pattern pattern = Pattern.compile("(?<=myvalue:)[0-9]*");
Matcher matcher;

if (pattern.matcher(input_row.Test).find()){
	System.out.println("Row Matched");
}
else{
	System.out.println("Row not Matched");
}

Which gave me the following result when I ran the job:

Hope this helps..!