topic Re: REGEX Lookbehind in Talend Studio

REGEX Lookbehind

Anonymous — Thu, 19 Apr 2018 15:26:18 GMT

I am using a regex,

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

to match a number after "myvalue:", the data looks like "myvalue:42", and I need the 42. This works in most regex engines, but I'm having trouble getting it to match in Talend. Please advise.

Re: REGEX Lookbehind

Anonymous — Thu, 19 Apr 2018 21:07:02 GMT

Why not substring?

String s = "myvalue:42";
System.out.println(s.substring(s.indexOf(":") + 1));

Re: REGEX Lookbehind

Anonymous — Thu, 19 Apr 2018 21:29:30 GMT

Thank you for the reply; love the avatar.

So you are suggesting I use something like

(myvalue:[0-9]*)

then use a tJavasomething to substring it?

Re: REGEX Lookbehind

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

bump

Re: REGEX Lookbehind

TRF — Sat, 21 Apr 2018 18:01:50 GMT

This one should also work:

row1.myField.replaceAll("^.*:", "")

and if you expect the result as an Integer:

Integer.parseInt(row1.myField.replaceAll("^.*:", ""))

This may appear in a tMap expression or in any place where you're able to enter a piece of Java code.

Hope this helps.

Re: REGEX Lookbehind

TRF — Sun, 22 Apr 2018 07:53:31 GMT

Did this help you?
If so, thank's to mark your case as solved (Kudo also accepted).

Re: REGEX Lookbehind

Anonymous — Mon, 23 Apr 2018 15:14:06 GMT

Hi @TRF, thank you for the suggestion. I will test and get back to you.

@TRFwrote:

This one should also work:
row1.myField.replaceAll("^.*:", "")
and if you expect the result as an Integer:
Integer.parseInt(row1.myField.replaceAll("^.*:", ""))
This may appear in a tMap expression or in any place where you're able to enter a piece of Java code.

Hope this helps.