topic Re: tMap : Java functions 'Ereplace' and 'Change' not working in Talend Studio

tMap : Java functions 'Ereplace' and 'Change' not working

Anonymous — Sat, 16 Nov 2024 14:29:04 GMT

Hi,
we're trying to use 'Ereplace' and 'Change' functions in expression builder of tMap component, but the result we get when testing it is ',,,,,,' (see screenshot attached).
Did we miss a step with these functions ?
Thx for your answer
EMahe

Re: tMap : Java functions 'Ereplace' and 'Change' not working

Anonymous — Mon, 14 Jan 2008 17:54:37 GMT

Hello,
Actually , the first parameter of this method is a regular expression.
You have to replace "." by "\." to get the correct result.
Regards,

Re: tMap : Java functions 'Ereplace' and 'Change' not working

_AnonymousUser — Thu, 24 Jul 2008 01:23:27 GMT

I have the same issue when trying to tmap a phone number from 11.111.1111 to 11-111-1111
Using StringHandling.EREPLACE(row1.HomePhone,".","-")
Gives the result of ---------
Using the "\." gives error Invalid Escape sequence.
Using "/." replaces nothing.
Please advise.

Re: tMap : Java functions 'Ereplace' and 'Change' not working

Anonymous — Thu, 24 Jul 2008 02:39:37 GMT

Hello
Try

StringHandling.EREPLACE(row1.HomePhone,"\\.","-")

Best regards

shong

Re: tMap : Java functions 'Ereplace' and 'Change' not working

_AnonymousUser — Thu, 24 Jul 2008 15:42:30 GMT

shong,
Excellent! That worked.
Now my question is what special characters require the \\ so they don't confuse tMap
Thanks!

Re: tMap : Java functions 'Ereplace' and 'Change' not working

Anonymous — Fri, 22 Nov 2013 20:10:06 GMT

Hi,
Is one better to use in certain circumstances than the other (referring to Ereplace vs. Change)?