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

[Anonymous]

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

[Anonymous]

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

[_AnonymousUser]

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.

[Anonymous]

Hello
Try

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

Best regards

shong

[_AnonymousUser]

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

[Anonymous]

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